[PHP-DB] Re Subject: SQL WHERE datetime > NOW

[Neil Smth]

Presumably where you are generating TO_DAYS(NOW()) you meant to say 
TO_DAYS(NOW())+1 ? (which is days *after* today !)

Also, you did not specify how it "does not work" - can you be mroe 
descriptive, what error message did you receive, how many rows did you 
expect and get out ?

Cheers - Neil.

At 19:29 03/01/2004 +0000, you wrote:
Message-ID: <[EMAIL PROTECTED]>
From: "John Dillon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Date: Sat, 3 Jan 2004 12:27:58 -0000
MIME-Version: 1.0
Content-Type: text/plain;
        charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Subject: SQL WHERE datetime > NOW
I'm trying to limit the results where a datatime field is later than 
todays date:

WHERE TO_DAYS(NOW())>TO_DAYS(MyTable.myfield)

doesn't appear to work.  Should it?  Should I not be nesting functions 
within an SQL statement like
this?

Thanks in advance for any ideas.

John
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php