how to select rows where column with date is NULL

[sladjana21]

Hello, is it possible to select rows form a table, where column with datetime is null,
something like:
SELECT * FROM MYTABLE WHERE DATE_COLUMN = NULL

there is no error, but doesn't return any row.

[debasisdas]

Please use the following query.

SELECT * FROM MYTABLE WHERE DATE_COLUMN IS NULL;

hope that solves your problem.

[dineshshweta]

Please use the following query.

SELECT * FROM MYTABLE WHERE DATE_COLUMN IS NULL;

hope that solves your problem.

Yes this is definitely works

Thanx