/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 vote203 views1 answer
Temperature conversion in c++
C++
0 vote155 views3 answers
Onoverlapbegin ue4 c++
C++
0 vote166 views1 answer
Sort function from bigest to smallest c++
C++
1 vote186 views1 answer
Get window position
C++
0 vote159 views1 answer
Age in days in c++
C++
0 vote169 views1 answer
List in c++
C++
2 votes169 views1 answer
Fatal error: opencv2/opencv.hpp: No such file or directory
C++
0 vote174 views1 answer
The program must enter a natural number n from the console and find the number previous to n that is not divisible by 2 , 3 and 5 .
C++
0 vote221 views1 answer
A function to create double quotes for alphabet in c++
C++
1 vote179 views2 answers
C++ random between two values
C++