Re: question about the date

[Barry Galbraith]

Dates are in the format yyyy-mm-dd in MySQL (thank goodness).

You can convert your strings that pretend to be dates to real dates with str_to_date()

https://dev.mysql.com/doc/refman/5.7/en/date-and-time-functions.html#function_str-to-date

mysql> SELECT str_to_date('01JAN2013', "%d%b%Y");
+------------------------------------+
| str_to_date('01JAN2013', "%d%b%Y") |
+------------------------------------+
| 2013-01-01                         |
+------------------------------------+
1 row in set (0.00 sec)

mysql>

Once you have your strings converted to real dates, you can use the builtin date handling functions.

Good luck,
Barry.