/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

5 votes102 views3 answers
Float max value c++
C++
0 vote106 views1 answer
Sum of first and last digit of a number in C++
C++
0 vote90 views1 answer
C++ rand include
C++
1 vote105 views3 answers
Print 2d array c++
C++
0 vote345 views1 answer
Cpp Case value is not a constant expression
C++
0 vote93 views1 answer
Sort strings by length and by alphabet
C++
17 votes109 views6 answers
Find max value in array c++
C++
1 vote94 views1 answer
0009:err:mscoree:CLRRuntimeInfo_GetRuntimeHost Wine Mono is not installed
C++
4 votes96 views3 answers
Count set bits in an integer c++
C++
14 votes101 views3 answers
Initialising 2d vector
C++