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 for fin
Hi
you can use
SELECT * FROM table WHERE expire>NOW();
or
SELECT * FROM table WHERE to_days(expire)>to_days(NOW());
HTH
Dobromir Velev
[EMAIL PROTECTED]
http://www.websitepulse.com/
- Original Message -
From: "Stephen of Blank Canvas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: W
