Calculate Date when End date May Be Null

alanhay · #1 (**permalink**) 02-20-04, 12:42

I'm trying to calculate the number of days between EITHER date_added and date_removed OR between date_added and today if date_removed is null.

It seems to me that I need, somehow, to get the timestamp returned by unix_timesamp(PR_DATE_ADDED) to be equal to today if it is null.

Been going round in circle with this for a few hours and geeting somewhere.

Using 3.22.

Anyone any ideas?

aus · #2 (**permalink**) 02-21-04, 13:52

I think that 3.22 supports these functions:

Code:

SELECT TO_DAYS(IFNULL(date_removed, NOW())) - TO_DAYS(date_added), ...

alanhay · #3 (**permalink**) 02-21-04, 14:01

Thanks.

Managed to get it working using the IFNULL statement.

Internet Services

Web Development

Digital Marketing

Consumer Tech