How to set the condition "non-zero timestamp"?

Question

SQL

Is there a correct alternative to such a notation?
WHERE field != '1753-01-01 00:00:00'

Answer 1

usually used is 'greater than' or 'less than' a specific date, or a date difference, or a comparison with a specific date. You can also make a Nullable date column and then you can check for null or a specific date.