Date/Time Data Types

Date/Time Data Types

Date/Time data types are used to store date and time values.

  • DATE: Stores date values. Format: YYYY-MM-DD.
  • TIME: Stores time values. Format: hh:mm:ss.
  • TIMESTAMP: Stores date and time values. TIMESTAMP values are stored as the number of seconds since the Unix epoch ('1970-01-01 00:00:00' UTC). Format: YYYY-MM-DD hh:mm:ss.
  • DATETIME: Stores date and time values. Format: YYYY-MM-DD hh:mm:ss. Do not include timezones.
  • YEAR: Stores year values.

Related concepts

→
Date/Time Data Types

Date/Time Data Types — Structure map

Clickable & Draggable!

Date/Time Data Types — Related pages:

SQL Create