/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 vote131 views1 answer
How the theam are store in database
C++
0 vote147 views1 answer
Find with hash set
C++
0 vote90 views1 answer
Prefix array algorithm in c++
C++
0 vote156 views2 answers
How can we create 4 digit random number in c++
C++
2 votes141 views1 answer
How to use python sleep function on c++
C++
1 vote178 views1 answer
Eosio name to string
C++
-1 vote139 views1 answer
Un aliment traduction espagnol
C++
0 vote136 views1 answer
Return multiple objects from a function C++ using references
C++
0 vote168 views1 answer
How to add an element to std::map
C++
0 vote135 views1 answer
Fenwick tree
C++