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

Saving data from a form into a file
Hey everybody,

Sorry, I am really new to PHP coding and such but a project kind of got thrust

Hom to make one url to open together with another url
I have a chat, which i want to be opened, as soon as the users login to the site. As it is now, when

Text file to .Dat file Conversion in PHP
Hi All,
Could anybody provide code for Text file to .Dat file Conversion in PHP.

Tha

RFQ Configuration - can you make PLANT field an optional field in ME42
Is there a way to make the plant field on an RFQ optional in change mode (ME42)?

Ariba 9r - SAP MM Integration
Hi experts,

The standard Ariba adapter for 9r creates a relationship between Cost Centers

can i optmize image to 50% quality before uploading 2 server
Hi there

i have jus written a php program to upload and display images but when i try to uplo

Serial number of exernal hard disk/Thumbdrive
Hi guys, I am new tio java networking concepts.Please tel me how to get Serial number of exernal

Not adding to db
Hi, I can't figure out why it won't add the record to the database. It's just a simple form to get

Trying to add functions to table
I have this list of characters and I'm trying to figure out what I have to do to put the results of

breaking a text file into paragraphs based on strings
I have a text file of email addresses that is all squished together. It looks like this:

abc

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