CELKO (5/27/2014)
I would use a different data model that has a correct temporal interval (start_date, end_date).
I agree completely Joe. However I find myself using this technique a lot in order to get someone else's data into that correct model.
You always have to start from where you are rather than where you'd like to be.