1#@!#!123s

: / home / tattooscyy / api / vendor / scrivo / highlight.php / test / markup / sql /

Filename : interval.txt

back

SELECT 
    CURRENT_TIMESTAMP 
    - INTERVAL 2 YEARS 
    + INTERVAL 1 MONTH 
    - INTERVAL 3 DAYS 
    + INTERVAL 10 HOURS 
    + interval 30 MINUTES 
    - INTERVAL 20 SECOND AS past_timestamp
FROM VALUES ("dummy");

WITH ts AS (
    SELECT CURRENT_TIMESTAMP AS now FROM VALUES ('dummy')
    ) 
SELECT 
    now - INTERVAL 1 DAY - INTERVAL 2 HOURS - INTERVAL 3 MINUTES - INTERVAL 4 SECONDS AS LONG_VERSION, 
    now - INTERVAL '1 2:3:4.100' DAY TO SECOND AS SHORT_VERSION
FROM ts;