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.