[Resolved] DATEDIFF mySQL question

Hi,

I'm trying to use the datediff function - checking out the difference between the field value (a timestamp) and the present time.

However, I cant get it to work - can I do the calc and include the field as one of the expressions to check?

I know you can with the other date functions (in the example I use date_add to show this).

I've tried lots of combinations - putting them in the same format was my last effort

SELECT DATE_ADD(due_date, interval 1 day ) as t1, DATE_FORMAT(NOW(), '%Y-%m-%d') as t2, DATEDIFF(t1,t2) as difference

Any ideas ?

I've never had much luck referencing aliased results in functions, but

DATEDIFF(DATE_ADD(due_date, interval 1 day ),CURRENT_DATE())

should do the trick

Thanks for the reply - still no joy:

DATEDIFF(due_date,CURRENT_DATE())

Also tried the date_add() version also..

I thought due_date was a timestamp - but its a Date format field. :o

Any ideas if its possible..

Having to go for a work around:

TO_DAYS(due_date) - TO_DAYS(now()) as date_diff

Not ideal at all probably is less effecient than the datediff method - but at least I can use my field! 🙂

:o Helps if the dev enviroment is the same specs as the live...

The live mysql is running a pre mysql 4.1 version :glare: