DB TIME ZONE

 

Oracle TIME ZONE

CAST(FROM_TZ (CAST(필드명 AS TIMESTAMP), '+00:00') AT TIME ZONE DBTIMEZONE) AS DATE)

 

MS-SQL TIME ZONE

CONVERT(datetime, SWITCHOFFSET(CONVERT(datetimeoffset, 필드명), '+09:00'))