Calculating # of days,hours,mins

Hi List.

I have a SQL question that should be fairly easy, but I haven't quite gotten it nailed down yet.

I am storing the in_date for a particular record. I need to calculate the number of days, hours, and minutes that have elapsed since the record was entered.

It should look something like this:

RECORD	AGE
---------------	--------
Item1		2 Days, 9 Hours, 32 Minutes

If any of you has done something similar, would you mind sharing your solution or steering me in the right direction? Received on Fri May 12 2000 - 11:18:19 CDT