/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

-2 votes137 views1 answer
Computer vision libraries C++
C++
2 votes143 views1 answer
Null c++
C++
0 vote125 views1 answer
Random 1 diem tren man hinh bang dev c
C++
117 votes279 views10 answers
Wattpad
C++
2 votes133 views3 answers
Print space in array cpp
C++
3 votes122 views3 answers
C vs c++ vs c#
C++
0 vote132 views1 answer
Texorpdfstring math in title latex
C++
0 vote144 views1 answer
Write a CPP program to calculate sum of first N natural numbers
C++
0 vote137 views1 answer
C++ power of two
C++
1 vote140 views1 answer
If not defined c++
C++