null in SQL means ‘unknown’.
This means that the result of using any comparison operator, like
=, with a
null is also ‘unknown’.
To check if a column is
NULL (or not
NULL), use the special syntax of
IS NULL (or
IS NOT NULL) instead of using
Applying that to your statement,
SELECT * FROM table WHERE timestamp IS NULL;