File: interval.txt

package info (click to toggle)
highlight.js 9.18.5%2Bdfsg1-1
  • links: PTS, VCS
  • area: main
  • in suites: bullseye
  • size: 6,672 kB
  • sloc: javascript: 40,928; python: 342; makefile: 160; sh: 11
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;