/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 vote118 views2 answers
Convert hex to decimal arduino
C++
1 vote59 views1 answer
Formal parameters c++
C++
0 vote94 views1 answer
Ue4 set size of widget c++
C++
0 vote113 views1 answer
How to use a non const function from a const function
C++
7 votes105 views1 answer
Convert binary to decimal c++ stl
C++
2 votes125 views2 answers
Resize two dimensional vector c++
C++
0 vote113 views1 answer
How to implement binders and decorators on c++ lik python?
C++
0 vote104 views1 answer
Appending string in c++
C++
42 votes149 views10 answers
Twitter
C++
0 vote102 views1 answer
Count bit 1 c++
C++