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
)