MySQL's TIMEDIFF has limit of 838:59:59, using DATEDIFF instead.
Start at the very beginning of a period (1st day of month, week, etc).