File: interval.txt

package info (click to toggle)
highlight.js 10.7.3%2Bdfsg-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 8,332 kB
  • sloc: javascript: 41,059; makefile: 157; python: 29; sh: 20
file content (17 lines) | stat: -rw-r--r-- 484 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
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;