Timezone conversion

Last updated
Save as PDF

/*
This is a sample script to demonstrate timezone conversion for date fields in CMO DWH

This script is intended to be used with SQL 2016+ and it utilises the 'AT TIME ZONE' funtion
*/

select
   de.EventNumber,
   de.EventDateTime [EventDateTime in UTC],
   de.EventDateTime at time zone 'utc' at time zone 'Central America Standard Time' [CST],
   de.EventDateTime at time zone 'utc' at time zone 'GMT Standard Time' [GMT],
   de.EventDateTime at time zone 'utc' at time zone 'AUS Eastern Standard Time' [AEST]
from DimEvent de
order by 1 desc