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

show random images
hey guys

can someone please suggest a way in which the following code can be edited so it onl

Need help with some php code :)
Hey! I'm quite new to this whole thing, so please don't fire me with shait on this one =D

I'm

Error in Configure System Landscape Directory phase
Hi

We are getting the error in Configure SLD phase ( 41 of 44 phase).

Please f

Dynamic Data + Sql Server 2005 Enterprise?
Hi! I have just started to learn ASP.NET, and it looks like it is quite a lot to learn. Im not reall

first id from db not showing
I have a php script which displays the content of a mysql table as a html table with sorting, delete

PHP MySQL and DATE
Hi everyone

I have a databse and in one of the columns I have date values such as 2009-March-

"SEO" URLs
Hey, I'm wondering how to go about creating and using these types of URLs. I'm presuming it's PHP th

UDS 4.0 Datatype issue
UDS 4.0.322 -- connecting to NI Labview 9.0

When using connection method: Cache with live

Upload, SSL and more php help
I recently just installed a ssl cert and do i use https for the whole site or just for the checkout.

Passing Arguments to execlp()
I'm writing a program that mimics a unix shell. It's supposed to take commands with arguments and ex

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