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

php sessions,logouts & the bloomin back button!
Hi All,

I've got a cms that members can log into. When they logout, the session is destroyed,

XML Grouping
I'm using xml_parse_into_struct to get all my elements, but now I need to group them. For example, h

Local file browser with php
Halo..

So this is what i want to create. I have a folder that i share and it has many movies.

WELCOME SCREEN
first of all let me tell you what does my script do,

it´s a very simple query to show a e

Search function
I am looking for some guidance from the experts.

I am trying to create a search function. It

Php WordPress help
I am writing the following code for making a plugin

<?php
header("Content-Type

FlashVar function how to insert variables
Hi guys. Im new in this forum and also new in php programming. Can you help me about this code?
<

Email logic not working
I would like to send an email using the php email() function then if it does execute i.e sends i wou

Calculating n! using vector
#include
#include
#include

using

defining website tags
Hi,

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