try_make_timestamp_ltz function

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

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

Syntax

try_make_timestamp_ltz(year, month, day, hour, min, sec [, timezone] )

try_make_timestamp_ltz(date, time [, timezone] )

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.
  • timezone: An optional STRING expression that evaluates to a valid time zone, such as CET or UTC.

Returns

A TIMESTAMP_LTZ, 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_ltz(2014, 12, 28, 6, 30, 45.887, 'CET');
  2014-12-27 21:30:45.887

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

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