Selecting an "empty" date formated field

Posted on 16th Feb 2014 07:03 pm by admin

How do you select an "empty" date field? I've tried the few ways I can think.
SQL> select prclid from parcel
2 where expdate = '';

no rows selected

SQL> select prclid from parcel
2 where expdate = null;

no rows selected
There are are "empty" date fields in the table as seen here.

SQL> select expdate from parcel
2 where prclid ='20131570070000';

EXPDATE

Your Answer:

Login to answer

Other forums

Save file by click
Hello.
I'm not understand how to save file from page. I'd like make link to file with save abil

dynamic table with forms
I have a table that is populated with mysql data and in teh first column there is a raido button tha

Help with looping
I have a comma separated list of colors taken from a database ($ICo) and a directory of images named

Form submissing with PHP and JQuery/Ajax
I have searched everywhere, but cannot find a solution for this... I have worked all day trying to g

reorder sql query
ok so i have this very simple code:
Code: $query = "SELECT search_keywords, COUNT(search_key

Checking if field is empty AND using !is_numeric
Hi lads,

Need to be able to display an error message (using isset?) that says "Cant lea

SAP Project Module
I have seen in the SAP Project Module,plan cost and budget are not equal and even difference is sign

License Issue - service type user
Hi,

I would like to understand the following issue regarding sap license.
I wish to

add to sql result
ok see rite now my sites hit counter is counted from the mysql visitor log i need to clear it aft

Consuming third party Payment Gateway API from Procedure.
Hi All,

First of all i would like to thank all the people of the oracle forum for providi