/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 votes187 views2 answers
Undefined reference to `pthread_create' c++
C++
0 vote199 views1 answer
How to create a custom event in ue4 c++
C++
0 vote190 views1 answer
Return multiple objects from a function C++ using references
C++
3 votes175 views2 answers
C++ vector extend vector
C++
14 votes260 views4 answers
Converting to string c++
C++
2 votes331 views1 answer
Lopping over an array c++
C++
0 vote198 views1 answer
Generate random string in c++
C++
0 vote192 views1 answer
How to clear a string in c++
C++
4 votes210 views1 answer
Gcd of two numbers c++
C++
23 votes205 views2 answers
C++ user input
C++