I'm trying to select entries in my Oracle 8 database that have a null, or empty, date. I'm using sql that looks like this:
select * from sales where sent_date = ''
... and it doesn't work. I'm unsure of the syntax for this. Should I be using the to_date function? Or replce the empty quotes with 'null'? I'd appreciate any help. Anyone have any advice?
Thanks,
-F Styles
select * from sales where sent_date = ''
... and it doesn't work. I'm unsure of the syntax for this. Should I be using the to_date function? Or replce the empty quotes with 'null'? I'd appreciate any help. Anyone have any advice?
Thanks,
-F Styles