sql server convert utc to pst SQL command
SELECT CONVERT(datetime, SWITCHOFFSET(CONVERT(datetimeoffset, '2022-01-01T12:00:00Z'), '-08:00')) AS PacificStandardTime;
SELECT CONVERT(datetime, SWITCHOFFSET(CONVERT(datetimeoffset, '2022-01-01T12:00:00Z'), '-08:00')) AS PacificStandardTime;