Google Git
Sign in
apache / hive / refs/heads/HiveAggregateReduceFunctionsRule / . / hplsql / src / test / queries / local / interval.sql
blob: e40fcbd229c7d23f783aeaec3ab0afd8e0a71b80 [file] [log] [blame]
DATE '2015-03-12' + 1 DAY;
TIMESTAMP '2015-03-12' + 1 DAY;
TIMESTAMP '2015-03-12 10:10:10.000' + 1 MICROSECOND;
DATE '2015-03-12' + NVL(NULL, 3) DAYS;
TIMESTAMP '2015-03-12' + NVL(NULL, 3) DAYS;
DATE '2015-03-12' - 1 DAY;
TIMESTAMP '2015-03-12' - 1 DAY;
TIMESTAMP '2015-03-12 10:10:10.000' - 1 MICROSECOND;
DATE '2015-03-12' - NVL(NULL, 3) DAYS;
TIMESTAMP '2015-03-12' - NVL(NULL, 3) DAYS;
TIMESTAMP '2015-03-12' - 1 DAY - 1 MICROSECOND;
date '2016-01-27' - interval '3' day;