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
|
select
cast(Date32("-144169-01-01") as string),
TzDate32("-144169-01-01,UTC"),
TzDate32("-144169-01-02,Europe/Moscow"),
TzDate32("-144169-01-01,America/Los_Angeles"),
cast(Date32("148107-12-31") as string),
TzDate32("148107-12-31,UTC"),
TzDate32("148108-01-01,Europe/Moscow"),
TzDate32("148107-12-31,America/Los_Angeles"),
cast(Date32("1-01-01") as string),
TzDate32("1-01-01,UTC"),
TzDate32("1-01-02,Europe/Moscow"),
cast(Date32("-1-12-31") as string),
TzDate32("-1-12-31,UTC"),
TzDate32("1-01-01,Europe/Moscow");
select
cast(Datetime64("-144169-01-01T00:00:00Z") as string),
TzDatetime64("-144169-01-01T00:00:00,UTC"),
TzDatetime64("-144169-01-01T02:30:17,Europe/Moscow"),
TzDatetime64("-144170-12-31T16:07:02,America/Los_Angeles"),
cast(Datetime64("148107-12-31T23:59:59Z") as string),
TzDatetime64("148107-12-31T23:59:59,UTC"),
TzDatetime64("148108-01-01T02:59:59,Europe/Moscow"),
TzDatetime64("148107-12-31T15:59:59,America/Los_Angeles"),
cast(Datetime64("1-01-01T00:00:00Z") as string),
TzDatetime64("1-01-01T00:00:00,UTC"),
TzDatetime64("1-01-01T02:30:17,Europe/Moscow"),
cast(Datetime64("-1-12-31T23:59:59Z") as string),
TzDatetime64("-1-12-31T23:59:59,UTC"),
TzDatetime64("1-01-01T02:30:16,Europe/Moscow");
select
cast(Timestamp64("-144169-01-01T00:00:00Z") as string),
TzTimestamp64("-144169-01-01T00:00:00,UTC"),
TzTimestamp64("-144169-01-01T02:30:17,Europe/Moscow"),
TzTimestamp64("-144170-12-31T16:07:02,America/Los_Angeles"),
cast(Timestamp64("148107-12-31T23:59:59.999999Z") as string),
TzTimestamp64("148107-12-31T23:59:59.999999,UTC"),
TzTimestamp64("148108-01-01T02:59:59.999999,Europe/Moscow"),
TzTimestamp64("148107-12-31T15:59:59.999999,America/Los_Angeles"),
cast(Timestamp64("1-01-01T00:00:00Z") as string),
TzTimestamp64("1-01-01T00:00:00,UTC"),
TzTimestamp64("1-01-01T02:30:17,Europe/Moscow"),
cast(Timestamp64("-1-12-31T23:59:59.999999Z") as string),
TzTimestamp64("-1-12-31T23:59:59.999999,UTC"),
TzTimestamp64("1-01-01T02:30:16.999999,Europe/Moscow");
|
