MySQL DATE, DATETIME, and TIMESTAMP Tutorials

In MySQL, date and time can be stored using 3 types, DATE, DATETIME, and TIMESTAMP. They are related.

MySQL recognizes DATE, DATETIME, and TIMESTAMP values in several formats.

• DATE type format: ‘YYYY-MM-DD’
• DATETIME type format: ‘YYYY-MM-DD hh:mm:ss’
• TIMESTAMP type format: a timestamp integer

Set default value as today or now

CREATE TABLE sale (
    `order_date`     DATETIME DEFAULT CURRENT_TIMESTAMP,
    `last_modified` DATETIME ON UPDATE CURRENT_TIMESTAMP,
    `confirm_time` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
)