How MySQL Handles Dates
March 15, 2009 2 comments
MySQL stores dates in the format YYYYMMDD, ie year, month, day. This is in acordance with the ISO (International Organization for Standardisation.
Dates and time in MySQL always follow the same order, largest unit first, then next largest, and so on to the smallest unit.
So dates are in the order year,month,date and
time is in the order [...]