Question

MySQL automatically converts a date or time value to a number if the value is used in a numeric context.

(a) True

(b) False

This question was posed to me during a job interview.

The query is from Date and Time Data Types in section Data Type Reference, Operators and Functions of MySQL

Answer 1

The correct answer is (a) True

Easiest explanation: MySQL automatically converts a date or time value into a number if the value is used in a numeric context and vice versa. A ‘zero’ value can also be represented in MySQL.