smalldatetime (Transact-SQL) [!INCLUDE sql-asdb-asdbmi-asa-pdw] Defines a date that is combined with a time of day. The time is based on a 24-hour day, with seconds always zero (:00) and without ...