Oracle vs. SQL Server vs. PostgreSQL – Date Date Type

This article talks about the behaviour of the DATE data type in different RDBMS.

The standard for DATE must be allowing it to only store DATE but not the TIME of the DAY. Oracle may have allowed TIME as well.

I would say that what SQL Server and PostgreSQL follows should be the absolute behavior in my opinion.

I think what SQL Server and Postgres does here are right as date should not include time. There could be another data type for it separately.