National EMSC Data Analysis Resource Center
Errors will inevitably creep into the database...
No matter how much effort you put into creating a good data collection system, errors will inevitably creep into the database making it necessary for data cleaning. Data cleaning can be intricate, time consuming, and costly, but it is a necessary step in any data-related project.
This section assumes you are familiar with basic database language and function. We will cover the following:
The Purpose of Data Cleaning >>
rev. 15-Jul-2006

Dates and Times: The Benefits of Using Standardized Formats
(...When working with databases or statistical packages, date and time formatting can become very confusing and even result in entries that are completely unreadable.)