/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 vote291 views2 answers
Bool to string arduino
C++
1 vote277 views1 answer
Il2cpp unity stuck c#
C++
0 vote333 views1 answer
What is c++ used for
C++
0 vote298 views1 answer
Prime or not in cpp
C++
1 vote298 views3 answers
Right shift in c++
C++
0 vote302 views2 answers
Insert image using set atribute
C++
1 vote301 views1 answer
Doubly linked list c++ code
C++
-1 vote331 views1 answer
Longest increasing subsequence nlogn c++
C++
0 vote286 views1 answer
Remove something from stringstream
C++
1 vote332 views1 answer
Chess perft 5
C++