Date & Timezone Getting Started Convert Timezone SELECT CAST( CAST( [DateColumn] AS DATETIMEOFFSET ) AT TIME ZONE 'SE Asia Standard Time' AS DATETIME2 ), ... FROM ... Read Mores Microsoft: Data Types - Datetimeoffset