Mysql Date and Time Types
From w3cyberlearnings
| # | Type | Decription | Format | Default Value |
|---|---|---|---|---|
| 1 | DATE | For storing date type | YYYY-MM-DD | NULL, '0000-00-00' |
| 2 | DATETIME | For storing datetime data | YYYY-MM-DD HH:MM:SS | NULL |
| 3 | TIMESTAMP | offer automatic update the current date and time | YYYYMMDDHHMMSS | CURRENT_TIMESTAMP,'0000-00-00 00:00:00',NULL,0,NOW() |
| 4 | Time | For storing time | HH:MM:SS | NULL, '00:00:00' |
| 5 | YEAR | For storing year | YYYY | NULL, '0000' |
