**HPL/SQL is included to Apache Hive since version 2.0** * [[home|Home]]\\ * [[why|Why HPL/SQL]]\\ * [[features|Key Features]]\\ * [[start|Get Started]]\\ * [[doc|HPL/SQL Reference]]\\ * [[download|Download]]\\ * [[new|What's New]]\\ * [[about|About]]
Sidebar
date-literal
DATE Literal - PL/HQL Reference
DATE literal allows you to specify a date constant using a string in 'YYYY-MM-DD' format. Then you can use this date value in any expression that expects a DATE data type.
Examples:
DATE '2014-12-20' DATE '2014-12-20' + 1 -- Result: 2014-12-21 of type DATE DATE '2014-12-20' - 1 -- 2014-12-19
Compatibility: Oracle, IBM DB2 and Teradata
Version: PL/HQL 0.01
See also:
Page Tools
