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

/* syntax version 1 */
pragma UseBlocks;

select
    DateTime::FromSeconds(fts_seconds) as ts_seconds,
    DateTime::FromMilliseconds(fts_msec) as ts_msec,
    DateTime::FromMicroseconds(fts_usec) as ts_usec,
    DateTime::FromMicroseconds(fts_msec * fts_msec) as ts_empty,

    DateTime::IntervalFromDays(fdays) as interval_days,
    DateTime::IntervalFromHours(fhours) as interval_hours,
    DateTime::IntervalFromMinutes(fminutes) as interval_minutes,
    DateTime::IntervalFromSeconds(fseconds) as interval_seconds,
    DateTime::IntervalFromMilliseconds(fmsec) as interval_msec,
    DateTime::IntervalFromMicroseconds(fusec) as interval_usec,

    DateTime::IntervalFromDays(fdays_overflow) as interval_days_overflow,
    DateTime::IntervalFromDays(fdays_null) as interval_null,
from Input