Steve Ruby writes:
>Ignore my hasty and wrong response from moments ago. you should be fine
>if date_resolved is a datetime type column if it is only a date you
>will need to use date_format to convert your date_sub(now()) to a date,
>otherwise the later returns datetime and cannot be compared to just date.
I'll try that, but it was my understanding from the manual that
the date functions were able to adapt between date, datetime, & timestamp
automagically?
--
Cindy
[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
