sql-tests.testcases.horology_functions.dateTimeOperatorsAccessible.sql Maven / Gradle / Ivy
-- database: presto; groups: qe, horology_functions
SELECT date '2012-08-08' + interval '2' day,
time '01:00' + interval '3' hour,
timestamp '2012-08-08 01:00' + interval '29' hour,
timestamp '2012-10-31 01:00' + interval '1' month,
interval '2' day + interval '3' hour,
interval '3' year + interval '5' month,
date '2012-08-08' - interval '2' day,
time '01:00' - interval '3' hour,
timestamp '2012-08-08 01:00' - interval '29' hour,
timestamp '2012-10-31 01:00' - interval '1' month,
interval '2' day - interval '3' hour,
interval '3' year - interval '5' month