/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 vote135 views1 answer
Libraries required for gaming in c++
C++
10 votes185 views3 answers
How to find maximum value in c++
C++
0 vote400 views1 answer
C++ find object in vector by attribute
C++
-2 votes210 views1 answer
Sum array c++
C++
11 votes197 views6 answers
How to take input in 2d vector in c++
C++
10 votes184 views3 answers
What is pi
C++
1 vote185 views1 answer
C++ 2d vector assign value
C++
1 vote133 views1 answer
Qt can't use ^ operator on qchar
C++
3 votes191 views1 answer
C++ how to make a negative float positive
C++
-2 votes190 views1 answer
Double pointers C++
C++