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
|
/* syntax version 1 */
$check = ($arg) -> {
return <|
upyear: DateTime::Update($arg, 2025),
inyear: DateTime::Update($arg, 148108 as Year),
upmonth: DateTime::Update($arg, NULL, 2),
inmonth: DateTime::Update($arg, 13 as Month),
upday: DateTime::Update($arg, NULL, NULL, 17),
inday: DateTime::Update($arg, 32 as Day),
update: DateTime::Update($arg, 2025, 2, 17),
ipdate: DateTime::Update($arg, 2025, 2, 29),
uptime: DateTime::Update($arg, NULL, NULL, NULL, 19, 24, 9),
iptime: DateTime::Update($arg, NULL, NULL, NULL, 25, 60, 61),
unhour: DateTime::Update($arg, 19 as Hour),
inhour: DateTime::Update($arg, 24 as Hour),
unminute: DateTime::Update($arg, 24 as Minute),
inminute: DateTime::Update($arg, 60 as Minute),
unsecond: DateTime::Update($arg, 9 as Second),
insecond: DateTime::Update($arg, 60 as Second),
unmsec: DateTime::Update($arg, 123456 as Microsecond),
inmsec: DateTime::Update($arg, 1234567 as Microsecond),
untzid: DateTime::Update($arg, 1 as TimezoneId),
intzid: DateTime::Update($arg, 1000 as TimezoneId),
|>
};
$typeDispatcher = ($row) -> {
$tm = $row.tm;
return <|
explicit: $check(DateTime::Split($tm)),
implicit: $check($tm),
|>;
};
$input = SELECT CAST(ftztimestamp64 AS TzTimestamp64) as tm FROM Input;
PROCESS $input USING $typeDispatcher(TableRow());
|
