Dates & time Scalar

make_time()

The time for the given parts

Arguments & returns

make_time(hour, minute, seconds)

Scalar
Overload link hourminuteseconds Returns
#01 BIGINTBIGINTDOUBLE TIME

Example

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

Engine example · Run to view results.

In other engines

BigQuerytime()

SELECT TIME(15, 30, 00)
In DuckDB
SELECT MAKE_TIME(15, 30, 00)

SQLGlot example ↗

Snowflaketime_from_parts()

SELECT TIME_FROM_PARTS(12, 34, 56)
In DuckDB
SELECT MAKE_TIME(12, 34, 56)

SQLGlot example ↗