aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/blocks/interval_add_date.sql
blob: bb395b7f7501161de62a9bf71227c9b9a9d7cacc (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
    b.ni + a.na,
    b.wi + a.na,
    b.ni + a.naz,
    b.wi + a.naz,
    b.ni + a.nd,
    b.wi + a.nd,
    b.ni + a.ndz,
    b.wi + a.ndz,
    b.ni + a.nt,
    b.wi + a.nt,
    b.ni + a.ntz,
    b.wi + a.ntz,

    b.ni + a.wa,
    b.wi + a.wa,
    b.ni + a.waz,
    b.wi + a.waz,
    b.ni + a.wd,
    b.wi + a.wd,
    b.ni + a.wdz,
    b.wi + a.wdz,
    b.ni + a.wt,
    b.wi + a.wt,
    b.ni + a.wtz,
    b.wi + a.wtz
FROM Dates as a CROSS JOIN Dates as b