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

/* postgres can not */
select cast(cast(1u as date) as datetime);
select cast(cast(1u as date) as timestamp);
select cast(cast(86400u as datetime) as timestamp);
select cast(cast(86400u as datetime) as date);
select cast(cast(86400000000ul as timestamp) as date);
select cast(cast(86400000000ul as timestamp) as datetime);