/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

5 votes146 views1 answer
Interpreter latex matlab
C++
29 votes121 views10 answers
Hello world c++
C++
3 votes115 views2 answers
Lambda function in c++
C++
0 vote115 views1 answer
Lap trinh file explorer c++
C++
0 vote124 views1 answer
CoinPiles
C++
0 vote118 views1 answer
C++ hours minutes seconds
C++
0 vote136 views1 answer
C if
C++
30 votes118 views10 answers
Google translate
C++
0 vote198 views5 answers
Palindrome String
C++
0 vote119 views1 answer
PUBG_APIKEY=<your-api-key> npm t
C++