try_make_timestamp_ntz function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Creates a timestamp without a time zone from date and time fields, or returns NULL if the timestamp cannot be created.

Syntax

try_make_timestamp_ntz(year, month, day, hour, min, sec)

try_make_timestamp_ntz(date, time)

Important

The time argument uses the TIME data type, which is in Beta.

Arguments

  • year: An INTEGER expression from 1 through 9999.
  • month: An INTEGER expression from 1 (January) through 12 (December).
  • day: An INTEGER expression from 1 through 31.
  • hour: An INTEGER expression from 0 through 23.
  • min: An INTEGER expression from 0 through 59.
  • sec: A numeric expression from 0 through 60.
  • date: A DATE expression that provides the year, month, and day fields.
  • time: A TIME expression that provides the hour, minute, and second fields.

Returns

A TIMESTAMP_NTZ, or NULL if an argument is out of bounds or the timestamp cannot be created.

If sec is 60, the function interprets it as 0 and adds one minute to the result.

Examples

> SELECT try_make_timestamp_ntz(2014, 12, 28, 6, 30, 45.887);
  2014-12-28 06:30:45.887

> SELECT try_make_timestamp_ntz(2014, 13, 28, 6, 30, 45.887);
  NULL

> SELECT try_make_timestamp_ntz(DATE'2014-12-28', TIME'06:30:45.887');
  2014-12-28 06:30:45.887
  • Last updated on