How to do both is not null and a not in statement in sql (oracle)?

Question

I am trying to say the statement

where date_end not in (null, 229)

I have already tried

where date_end not in (229) and date_end is not null

I have also tried

where date_end is not null or date_end not (229)

This is necessary because I am using the date_end in a to_date statement to create a date. I want to ignore 229 because of leap years and nulls because it will not respond in the to_date statement.

Answer 1

You can try:

where NVL(date_end, 229) != 229

Answer 2

You can simply write:

where date_end <> 229

This also filters out NULL values.

The same is true for not in:

where date_end not in (229)

If you want to be explicit, use and:

where date_end <> 229 and date_end is not null