/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 vote272 views1 answer
How to specify how many decimal to print out with std::cout
C++
0 vote260 views2 answers
Accepting multiple values from a function in cpp
C++
2 votes256 views1 answer
Unordered_map of pair and int
C++
2 votes254 views2 answers
C++ back()
C++
0 vote299 views1 answer
Array must be initialized with a brace-enclosed initializer
C++
0 vote251 views10 answers
Convert c program to c++ online
C++
29 votes238 views10 answers
Hello world c++
C++
0 vote258 views1 answer
Find subarray sum in c++
C++
-1 vote255 views2 answers
Why is my unity crashing
C++
1 vote266 views1 answer
C++ until
C++