/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 vote239 views1 answer
C function as paramter
C++
22 votes262 views4 answers
Getline cpp
C++
1 vote276 views1 answer
Chess perft 5
C++
0 vote261 views1 answer
Find Subarray sum using c++
C++
0 vote260 views1 answer
Esp
C++
0 vote248 views1 answer
Is power of 2
C++
0 vote242 views1 answer
How to point to next array using pointer c++
C++
-1 vote244 views1 answer
Int to hexadecimal in c++
C++
0 vote271 views1 answer
Stack overflow c++
C++
0 vote244 views1 answer
MPI_File_seek
C++