Dates & time Scalar

make_timestamp()

The timestamp for the given parts

Arguments & returns

2 overloads

Scalar

Overload link	`year`	Returns
#01	`BIGINT`	`TIMESTAMP`

Scalar

make_timestamp(
  year: BIGINT,
  month: BIGINT,
  day: BIGINT,
  hour: BIGINT,
  minute: BIGINT,
  seconds: DOUBLE
) → TIMESTAMP

SELECT make_timestamp(1992, 9, 20, 13, 34, 27.123456);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

SELECT TIMESTAMP_MICROS(x)

In DuckDB

SELECT MAKE_TIMESTAMP(x)

SELECT DATETIMEFROMPARTS(2013, 4, 5, 12, 00, 00, 0)

In DuckDB

SELECT MAKE_TIMESTAMP(2013, 4, 5, 12, 00, 00 + (0 / 1000.0))

SELECT TIMESTAMP_FROM_PARTS(2013, 4, 5, 12, 00, 00)

In DuckDB

SELECT MAKE_TIMESTAMP(2013, 4, 5, 12, 00, 00)