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

/* syntax version 1 */
SELECT
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, 2005)) as String),
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, 2200 as Year)) as String),
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, NULL, 7)) as String),
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, 13 as Month)) as String),
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, NULL, NULL, 20)) as String),
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, 32 as Day)) as String),
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, 2018, 2, 30)) as String),
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, NULL, NULL, NULL, 11, 10, 9)) as String),
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, 11 as Hour)) as String),
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, 24 as Hour)) as String),
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, 10 as Minute)) as String),
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, 60 as Minute)) as String),
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, 9 as Second)) as String),
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, 60 as Second)) as String),
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, 123456 as Microsecond)) as String),
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, 2000000 as Microsecond)) as String),
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, 100 as TimezoneId)) as String),
    cast(DateTime::MakeTzTimestamp(DateTime::Update(tm, 1000 as TimezoneId)) as String)
from (
    select
        cast(ftztimestamp as TzTimestamp) as tm
    from Input
);