Use datetime, smalldatetime, date, and time to store absolute date and time information. Use timestamp to store binary-type information.
