Oracle empty date

[Yamakazi]

I have a column called date_cre in my table and it holds a date or it holds nothing.

Now i want to select all records that hold nothing but my sql's don't seem to work. This is what i tried:

select from table where date_cre = '';
and
select from table where date_cre = null;

Both don't work. Does anyone have a clue?

TIA

[Euan_Fergusson]

Yamakazi wrote:

I have a column called date_cre in my table and it holds a date or it holds nothing.

Now i want to select all records that hold nothing but my sql's don't seem to work. This is what i tried:

select from table where date_cre = '';
and
select from table where date_cre = null;

Both don't work. Does anyone have a clue?

TIA

Try select * from table where date_cre IS NULL