/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 vote172 views1 answer
How to signify esc key in cpp
C++
42 votes212 views10 answers
Twitter
C++
3 votes147 views3 answers
Find an element in vector of pair c++
C++
6 votes173 views9 answers
Preorder to postorder converter online
C++
2 votes168 views1 answer
Cannot find "-lsqlite3" C++
C++
8 votes136 views3 answers
Print to console c++
C++
0 vote152 views1 answer
Iterate const vector
C++
0 vote147 views1 answer
How to convert int to FString c++ ue4
C++
10 votes200 views4 answers
Toupper c++
C++
4 votes172 views2 answers
Extended euclidean algorithm
C++