/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 vote185 views1 answer
Consell de forces polítiques de Catalunya
C++
0 vote145 views1 answer
Press enter to continue c++
C++
0 vote175 views1 answer
Std::ofstream file1(FILE_NAME, std::ios::app);
C++
0 vote189 views1 answer
Road sign detection and recognition by OpenCV in c
C++
0 vote199 views1 answer
Compile c++ MPI Program
C++
0 vote198 views1 answer
C++ get maximum value unsigned int
C++
0 vote209 views1 answer
C++ start process and get output
C++
0 vote178 views1 answer
Registering a new QML type
C++
12 votes195 views3 answers
C++ vector size
C++
0 vote189 views1 answer
New float array c++
C++