/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 vote344 views1 answer
C++ vector decimal to binary
C++
1 vote324 views3 answers
C++ map loop through key value
C++
1 vote333 views1 answer
C++ cout format
C++
3 votes301 views1 answer
Loop over multidimensional array c++
C++
0 vote339 views1 answer
Namespace c++
C++
0 vote351 views1 answer
Creating node in c++
C++
0 vote345 views1 answer
C++ move second line
C++
0 vote345 views1 answer
Tuple vector c++
C++
0 vote311 views1 answer
MPI_Sendrecv
C++
1 vote376 views1 answer
Hi cpp
C++