Functions/Dates & time/timezone
Dates & time Scalar

timezone()

Extract the timezone component from a date or timestamp

Arguments & returns

8 overloads

timezone(ts)

Scalar
Overload link ts Returns
#01 DATE BIGINT
#02 INTERVAL BIGINT
#03 TIMESTAMP BIGINT
#04 TIMESTAMP WITH TIME ZONE BIGINT

timezone(ts, col1)

Scalar
Overload link tscol1 Returns
#05 INTERVALTIME WITH TIME ZONE TIME WITH TIME ZONE
#06 VARCHARTIME WITH TIME ZONE TIME WITH TIME ZONE
#07 VARCHARTIMESTAMP TIMESTAMP WITH TIME ZONE
#08 VARCHARTIMESTAMP WITH TIME ZONE TIMESTAMP

Example

timezone example
SQL
Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.