aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/blocks/date_sub_interval.sql
blob: 9e9c6ce95b682459a4af3f1cdc2ba204afae4c8b (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
USE plato;

SELECT
    a.na - b.ni,
    a.na - b.wi,
    a.naz - b.ni,
    a.naz - b.wi,
    a.nd - b.ni,
    a.nd - b.wi,
    a.ndz - b.ni,
    a.ndz - b.wi,
    a.nt - b.ni,
    a.nt - b.wi,
    a.ntz - b.ni,
    a.ntz - b.wi,

    a.wa - b.ni,
    a.wa - b.wi,
    a.waz - b.ni,
    a.waz - b.wi,
    a.wd - b.ni,
    a.wd - b.wi,
    a.wdz - b.ni,
    a.wdz - b.wi,
    a.wt - b.ni,
    a.wt - b.wi,
    a.wtz - b.ni,
    a.wtz - b.wi

FROM Dates as a CROSS JOIN Dates as b