/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 vote194 views1 answer
What is push() c++
C++
0 vote195 views1 answer
2d array of zeros c++
C++
1 vote199 views3 answers
C++ split string on newline
C++
4 votes217 views2 answers
Gcd recursion c++
C++
3 votes203 views1 answer
Max three values c++
C++
0 vote225 views1 answer
How creat matrix column in c++
C++
15 votes193 views4 answers
C++ vector
C++
20 votes232 views4 answers
Cin getline
C++
-1 vote183 views1 answer
Sinonimo de tratar
C++
0 vote199 views1 answer
C++ write number to registry
C++