/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 vote247 views2 answers
Avl tree c++
C++
0 vote219 views1 answer
(1 & 1) in cpp
C++
4 votes230 views1 answer
Clear file before writing c++
C++
0 vote242 views1 answer
Stoi() c++
C++
9 votes225 views2 answers
C++ for in
C++
1 vote257 views1 answer
How to block window resize sfml c++
C++
0 vote235 views1 answer
Namespace file linking c++
C++
0 vote260 views1 answer
C++ write string
C++
29 votes199 views10 answers
Hello world c++
C++
31 votes178 views1 answer
When to use struct vs class c++
C++