At 8:22 PM -0700 9/15/01, Carl Schrader wrote:
>MYSQL
>
>I have a table with a date field. I have a query that needs to output
>only if NOW()<ed3(date field) ed2 is datetime.
ed3? ed2?
>
>The issue is this:
>select * from thesites where ED3>NOW()
>
>ED3='1999-12-31 00:00:00'
>
>the above query will output when ED3 is as above. NOW()='2001-09-15
>18:10:44'
>
>???
Doesn't sound right. Show us the output from the query, and the output
from "DESCRIBE thesites".
--
Paul DuBois, [EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
