/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

1 vote288 views1 answer
GetCurrentThreadId c
C++
0 vote290 views1 answer
While(n--)
C++
-1 vote259 views1 answer
Cod Cold War no recoil
C++
3 votes301 views3 answers
C++ string contains
C++
1 vote276 views1 answer
Rapidjson write stringbuffer to file
C++
0 vote286 views1 answer
Free pair c++
C++
1 vote265 views1 answer
C++ keyboard input
C++
0 vote265 views1 answer
Remove the jth object from the subset
C++
0 vote308 views1 answer
C++ write string
C++
0 vote487 views1 answer
Why constructor can't be static in c++
C++