/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

-1 vote313 views1 answer
Template function in class c++
C++
0 vote314 views1 answer
Who made c++
C++
7 votes303 views1 answer
How to make string get spaces c++
C++
0 vote334 views1 answer
How to find the left most bit 1 in binary of any number
C++
1 vote317 views1 answer
G++ -wall option meaning
C++
0 vote324 views1 answer
Fstream read write mode
C++
92 votes583 views6 answers
String reverse
C++
1 vote353 views2 answers
C++ get last element in array
C++
8 votes320 views6 answers
C++ while loop
C++
1 vote316 views1 answer
Is C++ useful in 2021
C++