/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 vote256 views1 answer
Yearly interest calculator c++ using for loop
C++
1 vote307 views1 answer
Priority queue ordered by second element
C++
0 vote260 views1 answer
C++ read matttrix from text file
C++
2 votes245 views1 answer
Print data type of a variable in c++
C++
1 vote280 views1 answer
How to return char* from function in c++
C++
1 vote253 views3 answers
Array Rotate in c++
C++
2 votes259 views1 answer
C++ read console input
C++
0 vote232 views0 answer
C++
0 vote265 views1 answer
Hola mundo c++
C++
5 votes274 views6 answers
Ngrok http
C++