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

Adding delete feature to my forum
Hello I am currently trying to add a delete feature to my forum. I believe I have everything built r

How to convert this array to string
I am having problems converting this array to a string
using print_r($val[1]); I get:
Code: [

Trigger tag in aspx is not coming
hi all ,iam new to ajax, iam using file upload inside the update pannel but right now i want to use

defining website tags
Hi,

What would be the best way to define tags for my site, such as website title, url etc.

Help! refer to a friend script with captcha code
Hi guys, I am posting on here in desperate need for some help with an ongoing search I have been doi

Uploading files/images via forms
Hey all, I am building a database for work that will contain some minor data on plant species along

Multiple Pages
Hi. Im very new to php. I'm trying to create a basic login/registration page.

So I have a bas

my sql select id and then update problem.
I need to select some auto incremented ids out of a database and then use those id in a where statem

Delete Client 066 Earlywatch
Hi all,

in former times client earlywatch was required for SAPs remote access to SAP inst

PRotect my POST DATA... FROM HTML ATTACKS
I need to like let's say

If a user submit's his Prayer and he put's <meta refresh stuf