After Mark's and Andy's posts, I have to reiterate that virtually all databases have an internal date data type, which makes a lot more sense to use than text strings, obviously, or roll-your-own integer solutions. MySQL, for example, has five: DATETIME, DATE, TIMESTAMP, YEAR, and TIME.