Which data and time datatype stores time value in ‘hh:mm:ss’ format?
(a) DATE
(b) TIME
(c) DATETIME
(d) TIMESTAMP
(a) DATE
(b) TIME
(c) DATETIME
(d) TIMESTAMP
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Correct choice is (b) TIME
For explanation I would say: MySQL has some variety of date and time datatypes. These datatypes are crucial for representing records in a table. The ‘TIME’ type represents a time value, stored in the ‘hh:mm:ss’ format.