[PHP-DB] SQL WHERE datetime > NOW

2004-01-03 Thread John Dillon
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 Mail

[PHP-DB] SQL WHERE datetime > NOW

2004-01-03 Thread John Dillon
gt; 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]> &