/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 vote135 views1 answer
How to scan array in c++
C++
99 votes309 views6 answers
How to convert int to string c++
C++
7 votes148 views2 answers
C++ threads
C++
2 votes138 views1 answer
Set was not declared in this scope
C++
213 votes325 views2 answers
C++ switch
C++
1 vote242 views1 answer
How to compile opencv c++ in ubuntu
C++
-1 vote153 views1 answer
C++ set console title
C++
0 vote223 views1 answer
Sort n characters in descending order c++
C++
10 votes113 views2 answers
Last index of string c++
C++
1 vote154 views1 answer
Std::string to qstring
C++