Answers for "sql server convert utc to pst SQL command"

C++

convert utc to est sql

select CONVERT(datetime, SWITCHOFFSET(dateTimeField, DATEPART(TZOFFSET, 
dateTimeField AT TIME ZONE 'Eastern Standard Time')))

Posted by: Guest on March-21-2020

Source

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;

Posted by: Guest on February-03-2021

Source

-2

tsql utf to local time

select 
 [MyUtcDate] + getdate() - getutcdate()
from [dbo].[mytable]

Posted by: Guest on June-15-2020

Source

Code answers related to "sql server convert utc to pst SQL command"

Code answers related to "C++"

Browse Popular Code Answers by Language

Python

Javascript

Whatever

Shell/Bash

CSS

Html

PHP

SQL

Java

Answers for "sql server convert utc to pst SQL command"

Code answers related to "sql server convert utc to pst SQL command"

Code answers related to "C++"

Browse Popular Code Answers by Language

Popular Programming Languages

Advertisements

Company

Compilers

Help

Connect with us