/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 vote287 views1 answer
Google test assert throw
C++
18 votes289 views5 answers
How to clear console c++
C++
15 votes295 views6 answers
Factorial
C++
0 vote296 views2 answers
Private static c++
C++
3 votes277 views2 answers
C++ find string in string
C++
1 vote250 views1 answer
Random number between x and y c++
C++
4 votes290 views1 answer
Arduino uno hello world
C++
0 vote273 views1 answer
Binary algebra cpp
C++
0 vote278 views1 answer
How to remove the % in zsh that show after running c++ file
C++
6 votes305 views6 answers
If statement C++
C++