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

/* postgres can not */
select Date("2001-01-01") - Datetime("2001-01-01T00:00:00Z");
select Date("2001-01-01") - Timestamp("2001-01-01T00:00:00Z");
select Datetime("2001-01-01T00:00:00Z") - Timestamp("2001-01-01T00:00:00Z");
select Datetime("2001-01-01T00:00:00Z") - Date("2001-01-01");
select Timestamp("2001-01-01T00:00:00Z") - Date("2001-01-01");
select Timestamp("2001-01-01T00:00:00Z") - Datetime("2001-01-01T00:00:00Z");