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 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.

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