How To Filter Blank Dates in Query

[trbyrne]

I have a table that contains a date field (dtnDOB). I want to pull all records from this table that have a value in this field. I've tried the following queries with no luck:

select * from <table> where dtndob<>''
select * from <table> where dtndob<>0
select * from <table> where dtndob>0

I'm not sure how to for the WHERE clause so that the result set excludes blank dates.

 

[trbyrne]

I forgot to mention that the dtnDOB field allows null values, and I am using PSQL v 8.6.

 

[trbyrne]

I just found the answer in this Tek-Tips thread:

http://www.tek-tips.com/viewthread.cfm?qid=1115432