What are the Temporal Data Types in MySQL?

Answer»

TYPE Name	Meaning
DATE	A date value, in ' CCYY-MM-DD ' Format
TIME	A Time value, in ' hh : mm :SS ' format
DATETIME	Date and time value, in ' CCYY-MM-DD hh : mm :ss ' format
TIMESTAMP	A timestamp value, in ' CCYY-MM-DD hh : mm :ss ' format
YEAR	A year value, in CCYY or YY format

Example: To select the records with an Order Date of "2018-11-11" from a table:

SELECT * FROM Orders WHERE OrderDate='2018-11-11'

Discussion