SQLZOO, Date and time types.

Date and time types.

SQL Server
The SQL standard permits three types. DATE, TIME and TIMESTAMP. A TIMESTAMP includes a date and a time. Several engines use the word TIMESTAMP for a different purpose.	Run the tidy code silently CREATE TABLE t_dttest( a DATETIME, b DATETIME, c DATETIME); INSERT INTO t_dttest VALUES ( '1962-05-20', '10:32:16', '1962-05-20 10:32:16'); SELECT * FROM t_dttest;
Specific to SQL Server
There is no DATE type. Use DATETIME instead. The term TIMESTAMP is used to indicate the date and time of a record. While this is sensible it is at odds with the SQL Standard in which "TIMESTAMP" indicates a date together with a time.

SQLzoo.net