Hi every one

I need help with the date function

I want to subtract two dates with type DATETIME to know how much time user spent.

will really appriciate it

regards
Yasir

select TO_DAYS(date1) - TO_DAYS(date2)

but that will give me no. of days not time I'm using datetime as type

regards

[Edit]: oops

select UNIX_TIMESTAMP(datetime1) - UNIX_TIMESTAMP(datetime2)

this will give you the difference in seconds

if the difference is less than 24 hours, you can then use SEC_TO_TIME to convert the result back to hh:mm:ss format

if it's more than 24 hours, you have to do additional arithmetic

Thanks man really appriciate it.
caio