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

form variables from database help.
Hi all,

I would like to have a form that gives you options based on the results of an mysql q

Multi image upload
I have a gallery to build and want to build a dynamic upload form to allow for $var number of fields

modifying query string with no page refresh
Hi everybody,
I've tried to get info about my problem all over the internet but i didn't find out

selection tool on raster image
Hi!
I have to implement in my app a selection tool which lets users to select region of any shape

User information
Hi All,
By using t-code SUIM we get all the user details,if suppose we donot have permission t

button.click += new eventhandler() not works in if(!ispostback)
i want to use button.clcik event in function VIewScrap() which is called in if(!ispostback) but itdo

php sessions,logouts & the bloomin back button!
Hi All,

I've got a cms that members can log into. When they logout, the session is destroyed,

Access website from only 1 computer...?
One of my customers wants his website to only be accessed by people in which they bought the website

AutoChoosing a CSS file based on URL
Hey everyone,

I have a site that has multiple URLs and CSS files.

Based on the URL tha

How to file_get_contents when login required?
Hello!

I am trying to read data from a page that you have to be logged into to view, I am try