Brian Dunning wrote:
Thanks Peter, that appears to be exactly what I'm looking for, but it
still gives an error and I've been through it with a fine-toothed comb,
tried different versions, parens, etc. Here is the exact SQL statement
I'm using, with your suggestion:
select
accounts.username,
meets.id as meet_id,
DATEDIFF( DATE_ADD( meets.creation, INTERVAL 30 DAY), NOW() ) as
expire_days
from
meets
left join
accounts on meets.id=accounts.id
....blah blah blah lots more stuff.
And here is the exact error I get:
You have an error in your SQL syntax. Check the manual that corresponds
to your MySQL server version for the right syntax to use near '(
DATE_ADD( meets.creation, INTERVAL 30 DAY), NOW() ) as expire
Can anyone see the problem? I sure can't.
DATEDIFF was added in 4.1.1. What version of mysql do you have?
<http://dev.mysql.com/doc/refman/4.1/en/date-and-time-functions.html>
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]