Eine Einführung in

SQL

Date and time types.

MS 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.
Execute tidy up code silently


Specific to MS 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.