Dates & time Scalar

make_timestamptz()

Reference: DuckDB 2.0.0

Arguments & returns

3 overloads

make_timestamptz(micros)

Scalar
Overload link micros Returns
#01 BIGINT TIMESTAMP WITH TIME ZONE

make_timestamptz(year, month, day, hour, minute, seconds)

Scalar
#02
make_timestamptz( year: BIGINT, month: BIGINT, day: BIGINT, hour: BIGINT, minute: BIGINT, seconds: DOUBLE ) โ†’ TIMESTAMP WITH TIME ZONE

make_timestamptz(year, month, day, hour, minute, seconds, timezone)

Scalar
#03
make_timestamptz( year: BIGINT, month: BIGINT, day: BIGINT, hour: BIGINT, minute: BIGINT, seconds: DOUBLE, timezone: VARCHAR ) โ†’ TIMESTAMP WITH TIME ZONE