How to convert from date to Hex in MySQL?

Question

I need to convert the minimum possible date in sql, that is 1753-01-01 in hexadecimal format, I have tried to do it this way but it shows me the same sentence.

SELECT cast('1753-01-01' AS binary(8))

Answer 1

I think we can try to use HEX function instead of CAST

SELECT HEX(dt)
FROM t

sqlfiddle