/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 vote211 views1 answer
Remove element from c++
C++
-1 vote213 views1 answer
A[12] = h + A[8]
C++
2 votes209 views4 answers
Substring in c++
C++
6 votes228 views3 answers
Print float up to 3 decimal places in c++
C++
0 vote214 views1 answer
Initialize string with length c++
C++
0 vote204 views1 answer
Move elements from vector to unordered_set
C++
0 vote238 views1 answer
How to format big numbers with commas in c++
C++
0 vote213 views1 answer
Https://www.google
C++
0 vote218 views1 answer
Use textchanged qt cpp
C++
0 vote203 views1 answer
Elements of set c++
C++