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

PHP Tab Control
Hi All,

I would like to have PHP tab control with/without Javascript.

But I want to r

DataTable Help Required
Hi all I am creating an app that utilises and MS Access back end and queries it quite a bit at vario

sql problems
I am having a small problem with my sql statement. it is inserting into 4 of the fields.

fie

Slashes
Have a small problem and I'm not able to understand why I'm getting the results I'm getting... and i

Is there a function ... auto send IP
Is there some function that can be sent to a ddns service that returns the ip address of a ddns forw

Advice on how to delete a mysql row using my form
Hi,

I am very new to php and am struggling to work out how to delete a portfolio item (a row

INSERT data problem!
After having an string with apostrophes ', double quotes " or any other special characters, suc

SAP Logon Failed
I tried to login to SAP through MMC.

When i click start and give password.

it

Join Query Help
Hi all,

I am having problems with the below code, which we shall call 'my first join query'!

How do I get the row number from from an sql table query
Hi all

I have a table that I query and it returns a number of rows.
mysql_num_rows($query)

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