在MySQL中插入日期的最佳方式

Question

I am getting a text file dump that I am processing into MySQL via PHP and the date format looks like "Jul 2012" or "Dec 2012", etc. I want to insert these into the database in a way that I could then select records in the future by date. Is there any way to convert these to the right format prior or a way to get SQL to automatically convert via a function?

Thanks so much.

Answer 1

Is there any way to convert these to the right format prior or a way to get SQL to automatically convert via a function?

Keep it at the DB level with MySQL's STR_TO_DATE().

For example:

SELECT STR_TO_DATE('Dec 2012','%b %Y');