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

No comments posted yet

Your Answer:

Login to answer
303 Like 43 Dislike
Previous forums Next forums
Other forums

Customizing message/behavior
Hi,I'm using the ASP.NET membership/authorization controls in my application. Some parts of my appli

"GROUP BY" in arrays
Well i'm looking to do something i usually could do easily using COUNT and GROUP BY if it was a sql

how do i make new line after *
First check this page here. and you see my report. Im pulling form a mysql db. I want to beable to m

Login page problems
I developed a website a few months ago and I am now having an issue with logging into it. The place

mysql select query problem
how can i select multiple fields from multiple table in one query like

i have table name t1 a

Form Help
Here is the form:

Line number On/Off | Expand/Contract<? include("../include/sess

Setting condidtions for an input box
Hi all,

I would like to set a condition in a txt box that says the number a user enters has t

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

Anti Spam Code
Ok where do i start? Probably by telling you I have very little working knowledge of PHP and that I

How do I use ValidatorCallout extender in Login control?
Hi,I'd like to customize the look and feel of the login control a little bit. One thing I'd love to

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash