/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 vote321 views2 answers
Unambiguous
C++
0 vote320 views1 answer
Why we use iostream in C++ programming
C++
0 vote311 views3 answers
Online convert c++ code to assembly language
C++
0 vote311 views1 answer
C++ if else if
C++
0 vote328 views1 answer
Hello world cc++
C++
0 vote314 views3 answers
Dynamic memory c++
C++
0 vote297 views1 answer
Remove something from stringstream
C++
0 vote297 views1 answer
How to use and in c++
C++
0 vote296 views1 answer
Cicli informatica c++
C++
0 vote340 views1 answer
Sprintf add two xeroes for a float number
C++