i want to find out the difference between two timestamp in days using mysql query. my timestamps are in seconds like (1328022418,1327417618). any one give me solution to this.
| SitePoint Sponsor |
i want to find out the difference between two timestamp in days using mysql query. my timestamps are in seconds like (1328022418,1327417618). any one give me solution to this.


Code:SELECT DATEDIFF( FROM_UNIXTIME(timestamp2) ,FROM_UNIXTIME(timestamp1) ) AS days_diff FROM daTable
Bookmarks