/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 vote177 views1 answer
Meter espacios en cadena c
C++
1 vote182 views1 answer
Qt messagebox
C++
0 vote180 views1 answer
Arduino falling edge
C++
1 vote184 views1 answer
C++ power
C++
0 vote180 views1 answer
Count spaces in string java
C++
0 vote169 views1 answer
How to download c++ portable compiler
C++
0 vote212 views1 answer
Armstrong number in cpp
C++
3 votes168 views1 answer
Vector unique in c++
C++
0 vote176 views1 answer
C++ iterate over vector of pointers
C++
0 vote190 views1 answer
C++ simple projects
C++