/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

0 vote225 views1 answer
Create new node in tree
C++
1 vote229 views1 answer
C++ std::fmin
C++
15 votes220 views4 answers
2d vector
C++
12 votes233 views2 answers
Underline in latex
C++
1 vote227 views1 answer
Priority queue c++ type of pairs
C++
5 votes264 views2 answers
String c++ if letter is lowercase
C++
0 vote246 views1 answer
Uint8_t in c++
C++
0 vote226 views1 answer
Cuda locks
C++
0 vote258 views1 answer
Opencv(4.5.1) c:\users\appveyor\appdata\local\temp\1\pip-req-build-kh7iq4w7\opencv\modules\imgproc\src\resize.cpp:4051: error: (-215:assertion failed) !ssize.empty() in function
C++
5 votes225 views1 answer
How to use comparator funtion in priority queue in c++
C++