/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 vote326 views1 answer
C++ stoi binary negative number string to decimal
C++
1 vote303 views1 answer
What is difference between single inverted and double inverted in programming languages
C++
0 vote346 views1 answer
Concatenate two vectors c++
C++
1 vote321 views1 answer
Rapidjson write stringbuffer to file
C++
0 vote310 views1 answer
Bash script add another user
C++
0 vote295 views1 answer
Break input stream into words
C++
6 votes314 views1 answer
Should i learn c or c++
C++
0 vote305 views1 answer
Upcasting in c++
C++
19 votes317 views1 answer
How to output to a file in c++
C++
5 votes288 views2 answers
Best way to take input in cpp
C++