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
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]>
&