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

/* syntax version 1 */

pragma UseBlocks;
insert into @t
    select
        cast(finterval1 as Interval) as `interval1`,
        cast(finterval2 as Interval) as `interval2`,
        cast(finterval3 as Interval) as `interval3`,
        cast(finterval4 as Interval) as `interval4`
from Input;

commit;
        
select
    DateTime::ToDays(`interval1`) as `interval1`,
    DateTime::ToDays(`interval2`) as `interval2`,
    DateTime::ToDays(`interval3`) as `interval3`,
    DateTime::ToDays(`interval4`) as `interval4`
from @t;