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;