ydb/yql/essentials/tests/sql/suites/datetime/date_bitcast.sql

/* postgres can not */
select bitcast(Yql::Date(AsAtom("1")) as Uint8);
select bitcast(Yql::Date(AsAtom("1")) as Int8);
select bitcast(Yql::Date(AsAtom("1")) as Uint16);
select bitcast(Yql::Date(AsAtom("1")) as Int16);
select bitcast(Yql::Date(AsAtom("1")) as Uint32);
select bitcast(Yql::Date(AsAtom("1")) as Int32);
select bitcast(Yql::Date(AsAtom("1")) as Uint64);
select bitcast(Yql::Date(AsAtom("1")) as Int64);

select bitcast(Yql::Datetime(AsAtom("1")) as Uint8);
select bitcast(Yql::Datetime(AsAtom("1")) as Int8);
select bitcast(Yql::Datetime(AsAtom("1")) as Uint16);
select bitcast(Yql::Datetime(AsAtom("1")) as Int16);
select bitcast(Yql::Datetime(AsAtom("1")) as Uint32);
select bitcast(Yql::Datetime(AsAtom("1")) as Int32);
select bitcast(Yql::Datetime(AsAtom("1")) as Uint64);
select bitcast(Yql::Datetime(AsAtom("1")) as Int64);

select bitcast(Yql::Timestamp(AsAtom("1")) as Uint8);
select bitcast(Yql::Timestamp(AsAtom("1")) as Int8);
select bitcast(Yql::Timestamp(AsAtom("1")) as Uint16);
select bitcast(Yql::Timestamp(AsAtom("1")) as Int16);
select bitcast(Yql::Timestamp(AsAtom("1")) as Uint32);
select bitcast(Yql::Timestamp(AsAtom("1")) as Int32);
select bitcast(Yql::Timestamp(AsAtom("1")) as Uint64);
select bitcast(Yql::Timestamp(AsAtom("1")) as Int64);

select bitcast(Yql::Interval(AsAtom("1")) as Uint8);
select bitcast(Yql::Interval(AsAtom("1")) as Int8);
select bitcast(Yql::Interval(AsAtom("1")) as Uint16);
select bitcast(Yql::Interval(AsAtom("1")) as Int16);
select bitcast(Yql::Interval(AsAtom("1")) as Uint32);
select bitcast(Yql::Interval(AsAtom("1")) as Int32);
select bitcast(Yql::Interval(AsAtom("1")) as Uint64);
select bitcast(Yql::Interval(AsAtom("1")) as Int64);