Make the start of the interval a date, and the end a datetime ending at 23:59:59