/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 vote157 views1 answer
Distructor of the node of the link list
C++
1 vote177 views1 answer
C++ print byte as bit
C++
29 votes196 views6 answers
How to convert string to int in c++
C++
2 votes170 views3 answers
Vector with initial size
C++
0 vote167 views1 answer
Swap first and last character of string in c++
C++
26 votes183 views2 answers
Remove element from vector on condition c++
C++
3 votes180 views1 answer
Abs c++
C++
0 vote178 views1 answer
C++ sorting and keeping track of indexes
C++
-1 vote172 views1 answer
How to make sound in c++
C++
1 vote166 views2 answers
Auto i cpp
C++