/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 vote82 views1 answer
Ue4 ftext c++
C++
0 vote144 views1 answer
Error in c++
C++
0 vote120 views2 answers
Constructor overloading in c++
C++
0 vote120 views1 answer
Is there garbage collection in c++
C++
45 votes155 views6 answers
Input in c++
C++
0 vote120 views1 answer
How to type cast quotient of two integers to double with c++
C++
0 vote121 views1 answer
What is g++ and gcc
C++
1 vote129 views1 answer
Implementation of Extended Euclidian theorem
C++
2 votes212 views1 answer
How to convert string to wchar_t in c++
C++
0 vote137 views1 answer
Cpp execute command
C++