« first day (3657 days earlier)    last day (267 days later) » 

7:00 PM
I guess this is a shameless plug, but feedback is welcome.

Been thinking about the vague phrase "detecting when the pattern in the data changes'. A form of anomaly detection I guess. I was thinking about those VARCHAR fields paired with datetimes. Combining with the notion of regular expression (regex) being one of those ways of "describing the pattern in the data", it occurred to me that changes in the regex that describes the data up to a given date would indicate that something about the data is different in its pattern. That change may not be a problem. But it is something which can be
 

« first day (3657 days earlier)    last day (267 days later) »