/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 vote312 views1 answer
What type is this c++
C++
-2 votes345 views1 answer
How to iterate through array in c++
C++
0 vote331 views1 answer
Floor and ceil in cpp
C++
0 vote329 views2 answers
How to compile with libstdc++ fedora
C++
0 vote321 views1 answer
TCA9548 I2CScanner Arduino
C++
3 votes486 views3 answers
Class cpp
C++
0 vote322 views1 answer
How to create a min priority queue of pair of int, int
C++
0 vote408 views3 answers
Simplest code for stack implementation in c++
C++
0 vote343 views1 answer
Convert char to C
C++
0 vote362 views2 answers
Avl tree c++
C++