getting DATE fields from pdox7 table?

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

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Jeffery Chow Fri, 20 Feb 1998 00:00

#54

Author: 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

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads