Question

define date and time datatypes

Answer 1

Answer:

The date and time data types for representing temporal values are DATE , TIME , DATETIME , TIMESTAMP , and YEAR . ... To define a column that includes a fractional seconds part, use the syntax type_name ( fsp ) , where type_name is TIME , DATETIME , or TIMESTAMP , and fsp is the fractional seconds precision.