ydb/yql/essentials/udfs/common/datetime2/test/cases/EndOf.sql

/* 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`)),
    $format(DateTime::StartOf(`tztimestamp`, Interval("PT13H"))),
    $format(DateTime::StartOf(`tztimestamp`, Interval("PT4H"))),
    $format(DateTime::StartOf(`tztimestamp`, Interval("PT15M"))),
    $format(DateTime::StartOf(`tztimestamp`, Interval("PT20S"))),
    $format(DateTime::StartOf(`tztimestamp`, Interval("PT7S"))),
from (
    select
        cast(ftztimestamp as TzTimestamp) as `tztimestamp`
    from Input
)
into result `Other cases`;