Number of Days Between Two UnixTime Formatted Dates MYSQL Use DATEDIFF select datediff(FROM_UNIXTIME(end_time), FROM_UNIXTIME(start_time) ) from date_table