fix 'date' and 'time' types.