i am working in php. i have a table EVENT. in which there are three fields, EventID,EventName and EventTime.
i have used datetime format for EventTime field.
now i want to write a query which return difference between current time and time of events.
I want my result to print like this:- eventID occurred 1 hour 20 minutes ago.
please suggest me how can i do this.
Thank you in advance.