Question

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

(a) True

(b) False

I had been asked this question in final exam.

Question is taken from Spatial Data Types in section Data Type Reference, Operators and Functions of MySQL

Answer 1

The correct option is (b) False

To explain: 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.