select ..., days(todate) - days(fromdate) as diffdays, ...