associate a set of date formats with mysql date type
checkpoint