/C++/Sql server convert utc to pst SQL command

Sql server convert utc to pst SQL command

Convert utc to est sql

select CONVERT(datetime, SWITCHOFFSET(dateTimeField, DATEPART(TZOFFSET, 
dateTimeField AT TIME ZONE 'Eastern Standard Time')))

Source: stackoverflow.com

Sql server convert utc to pst SQL command

-- all SQL Server versions
declare @utc_date datetime = getdate()
select @utc_date as utc_time_zone, 
  dateadd(hh, datediff(hh, getutcdate(), getdate()), @utc_date) as local_time_zone

--SQL Server 2016 and later
declare @utc_date datetime = getdate()
select @utc_date as utc_time_zone, 
  getdate() at time zone 'US Eastern Standard Time' as time_zone_est;

Source: popsql.com

Tsql utf to local time

select 
 [MyUtcDate] + getdate() - getutcdate()
from [dbo].[mytable]

-2

Source: stackoverflow.com

Similar codes

0 vote190 views2 answers
Private static c++
C++
0 vote182 views1 answer
Rectangle Area hackerrank in c++
C++
0 vote193 views1 answer
C++ vector push if not exist
C++
0 vote176 views1 answer
Std::random_device
C++
2 votes180 views1 answer
How to delete a node c++
C++
1 vote159 views2 answers
How to print text on C++
C++
2 votes154 views1 answer
Pointer dereference
C++
0 vote166 views1 answer
Softwareegg.courses4u
C++
0 vote134 views1 answer
C plus plus hello world
C++
1 vote153 views2 answers
Insert vector to end of vector c++
C++