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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
|
USE plato;
SELECT
ni * Int8("10"),
wi * Int8("10"),
ni * Uint8("11"),
wi * Uint8("11"),
ni * Int16("12"),
wi * Int16("12"),
ni * Uint16("13"),
wi * Uint16("13"),
ni * Int32("14"),
wi * Int32("14"),
ni * Uint32("15"),
wi * Uint32("15"),
ni * Int64("16"),
wi * Int64("16"),
ni * Uint64("17"),
wi * Uint64("17"),
FROM Dates;
SELECT
Int8("10") * ni,
Int8("10") * wi,
Uint8("11") * ni,
Uint8("11") * wi,
Int16("12") * ni,
Int16("12") * wi,
Uint16("13") * ni,
Uint16("13") * wi,
Int32("14") * ni,
Int32("14") * wi,
Uint32("15") * ni,
Uint32("15") * wi,
Int64("16") * ni,
Int64("16") * wi,
Uint64("17") * ni,
Uint64("17") * wi
FROM Dates;
SELECT
Interval("P1D") * i8,
Interval64("P1D") * i8,
Interval("P1D") * u8,
Interval64("P1D") * u8,
Interval("P1D") * i16,
Interval64("P1D") * i16,
Interval("P1D") * u16,
Interval64("P1D") * u16,
Interval("P1D") * i32,
Interval64("P1D") * i32,
Interval("P1D") * u32,
Interval64("P1D") * u32,
Interval("P1D") * i64,
Interval64("P1D") * i64,
Interval("P1D") * u64,
Interval64("P1D") * u64
FROM Dates;
SELECT
i8 * Interval("P1D"),
i8 * Interval64("P1D"),
u8 * Interval("P1D"),
u8 * Interval64("P1D"),
i16 * Interval("P1D"),
i16 * Interval64("P1D"),
u16 * Interval("P1D"),
u16 * Interval64("P1D"),
i32 * Interval("P1D"),
i32 * Interval64("P1D"),
u32 * Interval("P1D"),
u32 * Interval64("P1D"),
i64 * Interval("P1D"),
i64 * Interval64("P1D"),
u64 * Interval("P1D"),
u64 * Interval64("P1D")
FROM Dates;
|
