Convert UTC Time to Pacific Time Query:crazy:

• martin.zamora

  SSC Rookie

  Points: 47

  More actions

  February 25, 2016 at 2:23 pm

  #1861258

  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 .