Question

MySQL how to declare a datetime variable?

Answer 1

set @dateTo :=cast('2016-09-30' as date);

SELECT

id, last_updated

FROM

(SELECT * FROM transactions_history WHERE id = 81867533) h