Dates & time Scalar

timezone()

Extract the timezone component from a date or timestamp

Reference: DuckDB 2.0.0

Arguments & returns

13 overloads

timezone(ts)

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

timezone(offset, time_tz)

Scalar
Overload link offsettime_tz Returns
#08 INTERVALTIME WITH TIME ZONE TIME WITH TIME ZONE

timezone(timezone, timestamp)

Scalar
Overload link timezonetimestamp Returns
#09 VARCHARTIME WITH TIME ZONE TIME WITH TIME ZONE
#10 VARCHARTIMESTAMP TIMESTAMP WITH TIME ZONE
#11 VARCHARTIMESTAMP WITH TIME ZONE TIMESTAMP
#12 VARCHARTIMESTAMP_NS TIMESTAMPTZ_NS
#13 VARCHARTIMESTAMPTZ_NS TIMESTAMP_NS

Example

timezone example
SQL
Haybarn WASM 2.0.0-rc12 ยท In your browser

Engine example ยท Run to view results.