/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 vote129 views1 answer
Print linkedstack cpp
C++
2 votes127 views2 answers
What s[i]-'0' does
C++
0 vote188 views1 answer
Primtiive calculator in c++
C++
1 vote131 views1 answer
Plus (programming language)
C++
2 votes134 views1 answer
Dlopen failed: library "libomp.so" not found
C++
0 vote130 views1 answer
Initialize multiple variables to 0 c++
C++
0 vote166 views2 answers
Decrement c++
C++
0 vote122 views2 answers
C++ string to wstring
C++
0 vote126 views1 answer
Kadane algo
C++
3 votes123 views1 answer
Cpp boilerplate
C++