getting DATE fields from pdox7 table?

Article View: borland.public.intrabuilder.data.sql

Article #54

Back to borland.public.intrabuilder.data.sql Previous Next

#54

From: Jeffery Chow
Date: Fri, 20 Feb 1998 00:00

17 lines
985 bytes

Hi, I'm having a problem getting the WHERE clause in my SELECT statement 
to filter out rows when a DATE/TIME field is used in that WHERE clause.

Example:
SELECT * FROM signups WHERE "start_time" IS NULL AND "start_date" IS NULL

will get me every row in signups, irrespective of whether or not 
start_time or start_date are null. Is there something wrong in my query?
I'm not really sure how SQL deals with date/time datatypes.
I've also tried
WHERE "start_time" LIKE '' and 
WHERE "start_time" = 0, both with limited success. =)

Please respond if you have any comments,

Jeff

Technical Details

Message-ID: <6ckp8c$2gp$1@neptune.uniserve.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101d9a,511d0f10f4eb1eea,start
X-Google-Attributes: gid101d9a,public
From: Jeffery Chow <jchow@shell.uniserve.com>
Subject: getting DATE fields from pdox7 table?
Date: 1998/02/20
Message-ID: <6ckp8c$2gp$1@neptune.uniserve.com>
X-Deja-AN: 327039455
Organization: Uniserve
Newsgroups: borland.public.intrabuilder.data.sql