Why is a date that has not yet arrived (2115-12-30 19:58:20) when ORDER BY does not display the date DESC first?

Question

SQL

Under certain conditions, I write the date NOW() + INTERVAL 100 YEAR so that the string is always the first (and so that it is convenient to return it to the normal form str_replace-uv 21 by 20).
But why is the date that has not yet arrived (2115-12-30 19:58:20) when ORDER BY does not display the date DESC first? Broke his head.

Answer 1

Specify the version and brand of SQL, how exactly is the date stored - as a timestamp or just a string?
У timestamp, может быть проблема переполнения

Answer 2

Храни 2115-12-30 как 21151230.

Answer 3

ORDER BY date_add >= NOW() DESC, id DESC - в моём случае так заработала, насколько это применимо и насколько костыль? Я не особо разумею в SQL..