DATE and TIME

Learn date and time types.

DATE holds a date, TIME a time, TIMESTAMP both. The date format is YYYY-MM-DD.

CREATE TABLE orders (
  order_date DATE,
  order_time TIME,
  created_at TIMESTAMP
);

Order_date holds the date, order_time the time, created_at both.

The table orders is created.

DATE and TIME — details

Date literals go in single quotes: '2026-01-15'. TIMESTAMP can be auto-updated; with DEFAULT CURRENT_TIMESTAMP it fills at insert time.

Add an order_date DATE column to orders.

Show example solution

CREATE TABLE orders (
  order_date DATE
)

Date type

CREATE TABLE t (d ____);

Show answer

CREATE TABLE t (d DATE);

Next lesson: BOOLEAN