Format Date From Text File into MySQL

[likelylad]

I am currently writing a script that will take info from a text file and put it into a MySQL database.

I can import all information from the text file into the database apart from dates.

The dates in the text file are in the format 06-DEC-05 and to get it into MySQL I need it in the format yyyy-mm-dd

I have tried the following and it doesn't work

date(Y-m-d,$datefromtextfile)

Thanking in advance for any help received

 

[likelylad]

I should have done a bit more research before posting this question.

My solution is

date("Y-m-d",strtotime($datefromtextfile))