/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 vote114 views1 answer
What is the system function in c++
C++
0 vote113 views1 answer
. The cout with the insertion operator (<<) is used to print a statement
C++
-1 vote128 views6 answers
C to c++ converter online
C++
0 vote138 views1 answer
Alias namespaces c++
C++
8 votes119 views2 answers
C++ function of find maximum value in an array
C++
1 vote107 views1 answer
Getline cin is being skipped
C++
5 votes108 views1 answer
Master library in c++
C++
0 vote113 views1 answer
The number of ones int bitset
C++
0 vote111 views2 answers
Change colour of output to terminal c++
C++
0 vote113 views1 answer
C++ suare
C++