aboutsummaryrefslogtreecommitdiffstats
path: root/yql/essentials/tests/sql/suites/blocks/date_add_interval.sql
blob: 3a920ad0e3da3bc0d7a8d790a00dcebdb5e7730a (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