Type Description
DATETIME YYYY-MM-DD HH:MM:SS from 1000-01-01 00:00:00 to 9999-12-31 23:59:59
DATE YYYY-MM-DD from 1000-01-01 to 9999-12-31
TIMESTAMP YYYYMMDDHHMMSS
TIME HH:MM:SS
YEAR YYYY