Hi,

--Convert from UTC to PST Version 2008 or higher

--Check: https://msdn.microsoft.com/en-us/library/bb677244.aspx

--Here an example but, match it to your case 😉

select CAST(SWITCHOFFSET(CAST(utc_column as varchar),'-08:00') AS DATETIME) AS PST

Regards .