/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

1 vote422 views1 answer
Can you verify adsense no ssl certificate
C++
4 votes333 views2 answers
Sqrt cpp
C++
1 vote341 views1 answer
C++ vector move element to front
C++
18 votes371 views5 answers
C++ random number
C++
0 vote360 views1 answer
C++ hello world linux
C++
1 vote328 views2 answers
Read file into vector
C++
-1 vote367 views1 answer
How to define range of numbers inside a if condition in c++
C++
101 votes546 views6 answers
How to turn int into string c++
C++
0 vote340 views1 answer
Std::ifstream cant read file to large
C++
0 vote345 views1 answer
Format string cpp
C++