RE: SELECT with DATE

2003-02-07 Thread Victor Pendleton
select columnName from tableName where expireColumnDateValue >= Now() -Original Message- From: Stephen of Blank Canvas [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 05, 2003 10:18 AM To: [EMAIL PROTECTED] Subject: SELECT with DATE Can anyone point me in the right direction

Re: SELECT with DATE

2003-02-07 Thread Dobromir Velev
t;[EMAIL PROTECTED]> Sent: Wednesday, February 05, 2003 18:18 Subject: SELECT with DATE > Can anyone point me in the right direction for finding a method of only > creating a query that selects records from a dB where today's date is > less than the column 'expire', w

SELECT with DATE

2003-02-06 Thread Stephen of Blank Canvas
Can anyone point me in the right direction for finding a method of only creating a query that selects records from a dB where today's date is less than the column 'expire', which is in DATE format. The purpose of this is to automatically stop display special offers. Thanks Stephen