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 Serve

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.