• Home
• com.facebook.presto
• presto-product-tests
• 0.288.1
• source code
• dateTimeOperatorsAccessible.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

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