/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 vote282 views1 answer
Even number program in c++ using for loop stack overflow
C++
0 vote355 views1 answer
Find number of 1s in a binary cv::mat image
C++
12 votes286 views6 answers
Loop through map c++
C++
0 vote305 views1 answer
C++ typedef template class
C++
0 vote300 views1 answer
271533778232847
C++
24 votes322 views5 answers
Size of array
C++
0 vote283 views1 answer
C++ suare
C++
19 votes296 views1 answer
C++ writing to file
C++
0 vote264 views1 answer
C++ while loop decrement
C++
0 vote289 views1 answer
How to allocate memory for vector c++
C++