Sidebar

HPL/SQL is included to Apache Hive since version 2.0

timestamp-literal

TIMESTAMP Literal - PL/HQL Reference

TIMESTAMP literal allows you to specify a timestamp constant using a string in 'YYYY-MM-DD HH:MI:SS.FFF' or 'YYYY-MM-DD-HH.MI.SS.FFF' format.

You can use this timestamp value in any expression that expects a TIMESTAMP data type.

Examples:

TIMESTAMP '2015-03-03 11:39:31.123'
 
TIMESTAMP '2015-03-03-11.39.31.123'   -- DB2 syntax

Notes:

  • Fractional part is optional

Compatibility: Oracle, IBM DB2.

Version: PL/HQL 0.03

See also: