My SQL comes with the following data types for storing a date or a date/time value in the database.
NOTE : This all the above data types are used in the table.
The syntax is the same as creating a table but where we declare date & time type like varchar, int etc. there we need to write the above data type.
when we insert data into this data type we must follow the above formate of date, time and DateTime.
NOTE: Inserted data into this data type must be inside ( ' ' ).