Question

Data type date consists of ten position where as data type time consists of

Answer 1

Answer:

The data type DATE consists of ten positions where as the data type TIME consists of eight positions

Answer 2

Data type DATE consists of ten positions whereas data type TIME consists of eight positions.

• The format for the DATE data type is YYYY-MM-DD  and its range is between 0001-01-01 - 9999-12-31.
• The format for TIme data type is hh:mm:ss and its range is between 00:00:00.0000000 - 23:59:59.9999999.
• Data type DATE takes 5 bytes whereas TIME data type takes 3to 5 bytes.