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