CONVERT_TZ
Converts a datetime from one time zone to another.
Analyze Syntax
func.convert_tz(<datetime>, <from_tz>, <to_tz>)
Analyze Examples
func.convert_tz('2024-01-01 12:00:00', 'UTC', 'America/New_York')
┌───────────────────────┐
│ '2024-01-01 07:00:00' │
└───────────────────────┘
SQL Syntax
CONVERT_TZ(<datetime>, <from_tz>, <to_tz>)
SQL Examples
SELECT CONVERT_TZ('2024-01-01 12:00:00', 'UTC', 'America/New_York');
┌─────────────────────┐
│ 2024-01-01 07:00:00 │
└─────────────────────┘