/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 vote226 views3 answers
How to take space separated input in c++
C++
0 vote200 views1 answer
Cout.flush() in c++
C++
0 vote189 views1 answer
Cout wchar_t
C++
2 votes194 views2 answers
Selection sort c++ algorithm
C++
0 vote203 views1 answer
Find N Unique Integers Sum Up to Zero
C++
0 vote196 views1 answer
C++ pass char array by reference
C++
0 vote198 views1 answer
C++ get type name of object
C++
0 vote209 views2 answers
What are manipulators in c++
C++
35 votes216 views6 answers
Hello world cpp
C++
1 vote190 views1 answer
What is _asm in C++
C++