Donate. I desperately need donations to survive due to my health

Get paid by answering surveys Click here

Click here to donate

Remote/Work from Home jobs

How to return the day, hours and minutes after comparing 2 from_unixtime(date)?

on

I have created a query to select my lists of fields from some join tables. I am trying to compare between 2 from_unixtime(date) and return the result in 3 new columns which will be the difference in days, hours and minutes of the 2 from_unixtime(date).

Sample query is as per below:

SELECT from_unixtime(bug.date_submitted),
from_unixtime(history.date_modified),
from_unixtime(history.date_modified) - from_unixtime(bug.date_submitted) as 'resolve date'

How do i return the resolve date by days, hours and minutes?

Comments

Post a Comment