how do i convert month name to a number?

[pushyr]

i googled this but cant find the answer and i'm guessing it's so simple....

this is my date format... 2007-Nov-13

and i would like to insert it into DATE in mysql, to do this i must convert the abbreviated month name into it's numeric equivalent

i have the choice of either doing this as the full string 2007-Nov-13, or just the month itself...as year, month and date are in an array... [1] [2] [3]

 

[jpadie]

function mysqldate($date){
 return date("Y-m-d", strtotime($date));
}