Breaking News: Grepper is joining You.com. Read the official announcement!

sql server convert utc to pst SQL command

LionKing answered on February 3, 2021 Popularity 4/10 Helpfulness 8/10

answer sql server convert utc to pst SQL command

sql server convert utc to pst SQL command

Comment

-- 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;

Popularity 4/10 Helpfulness 8/10 Language cpp

Source: popsql.com

Tags: c++ command pst sql sql-server utc

Link to this answer
Share Copy Link

Contributed on Feb 03 2021

LionKing

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

sql server convert utc to pst SQL command

Contents

More Related Answers

sql server convert utc to pst SQL command

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.