/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 vote175 views1 answer
PI IN C++ WITH CMATH
C++
0 vote201 views1 answer
Initialize 2d array c++ memset
C++
46 votes275 views3 answers
Data types in c++
C++
0 vote189 views1 answer
C++ argument list for class template is missing
C++
0 vote181 views1 answer
What is xor_eq c++
C++
0 vote172 views1 answer
Remove digit from number c++
C++
0 vote204 views1 answer
C++ class constructor variable arguments
C++
5 votes210 views1 answer
Screen record ios simulator
C++
0 vote178 views7 answers
Online compiler to calculator time complexity
C++
1 vote183 views3 answers
Type casting in cpp
C++