/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 vote141 views1 answer
Lists occurrences of characters in the string c++
C++
2 votes135 views1 answer
C++ custom comparator for elements in set
C++
0 vote164 views1 answer
Ubuntu dotnet create blazorserver linux
C++
0 vote142 views1 answer
How to run cpp using gcc vscode
C++
0 vote123 views1 answer
SFML texture from file max size
C++
3 votes146 views3 answers
Find last occurrence of character in string c++
C++
0 vote137 views1 answer
Makefile for single cpp file
C++
3 votes152 views1 answer
C++ declaring and initializing strings
C++
1 vote172 views1 answer
Unique_ptr header file
C++
0 vote151 views1 answer
Program to swap max and min in matrix
C++