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
|
/* syntax version 1 */
$format = DateTime::Format("%Y-%m-%d %H:%M:%S %Z");
select
$format(DateTime::EndOfMonth(TzDateTime('2023-07-07T01:02:03,Europe/Moscow'))),
$format(DateTime::EndOfMonth(Date('2023-08-08'))),
$format(DateTime::EndOfMonth(Date('2023-09-09'))),
$format(DateTime::EndOfMonth(Date('2023-02-02'))),
$format(DateTime::EndOfMonth(Date('2024-02-02')))
into result `Normal cases`;
$tsMin = '1970-01-01T00:00:00.000000';
$tsMax = '2105-12-31T23:59:59.999999';
$tsBelow = '1969-12-31T23:59:59.999999';
$tsAbove = '2106-01-01T00:00:00.000000';
select $format(cast($tsMin || 'Z' as Timestamp))
, $format(DateTime::EndOfMonth(cast($tsMin || 'Z' as Timestamp)))
, $format(DateTime::EndOfMonth(cast($tsMin || ',Atlantic/Madeira' as Timestamp)))
into result `Minimal timestamp value`;
select $format(cast($tsMax || 'Z' as Timestamp))
, $format(DateTime::EndOfMonth(cast($tsMax || 'Z' as Timestamp)))
, $format(DateTime::EndOfMonth(cast('2105-12-12T00:00:00Z' as Timestamp)))
, $format(DateTime::EndOfMonth(cast($tsMax || ',Atlantic/Azores' as Timestamp)))
into result `Maximum timestamp value`;
select $format(cast($tsBelow || ',Atlantic/Azores' as TzTimestamp))
, $format(DateTime::EndOfMonth(cast($tsBelow || ',Atlantic/Azores' as TzTimestamp)))
into result `Timestamp below minimum`;
select $format(cast($tsAbove || ',Atlantic/Madeira' as TzTimestamp))
, $format(DateTime::EndOfMonth(cast($tsAbove || ',Atlantic/Madeira' as TzTimestamp)))
into result `Timestamp above maximum`;
select
$format(DateTime::EndOfYear(`tztimestamp`)),
$format(DateTime::EndOfQuarter(`tztimestamp`)),
$format(DateTime::EndOfMonth(`tztimestamp`)),
$format(DateTime::EndOfWeek(`tztimestamp`)),
$format(DateTime::EndOfDay(`tztimestamp`)),
from (
select
cast(ftztimestamp as TzTimestamp) as `tztimestamp`
from Input
)
into result `Other cases`;
|
