/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 vote109 views1 answer
Create a bitset of 1024 bits,
C++
1 vote109 views1 answer
Cpp map iterate over keys
C++
0 vote118 views1 answer
Normal Initialisation of 3D Vector
C++
11 votes109 views3 answers
Count occurrences of character in string c++
C++
0 vote120 views1 answer
Get player pawn
C++
-1 vote106 views2 answers
Open url from dev cpp
C++
1 vote116 views1 answer
C++ keyboard input
C++
0 vote112 views1 answer
Program in c++ for simple interest rate
C++
4 votes114 views1 answer
Gcd of two numbers c++
C++
17 votes104 views2 answers
Initialize an array in c++
C++