Dates & time Scalar

timezone_hour()

Extract the timezone_hour component from a date or timestamp

Reference: DuckDB 1.5.5

Arguments & returns

4 overloads

timezone_hour(ts)

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

Example

timezone_hour example
SQL
Haybarn WASM 2.0.0-rc12 · In your browser

Engine example · Run to view results.