[triplebig]

i have a list of date in text i want to convert to mysql


the date now is in dd.mm.yy format ( eg 01.01.88 )

i want to change it to date format yyyy-mm-dd : 01-01-1988

How do i do that ? i want to insert the text date to mysql table but in yyyy-mm-dd from dd.mm.yy

[job0107]

PHP Code:

$d = "01.01.88";
$dateParts = explode(".",$d);
$mysqlDate = date("Y-m-d", mktime(0, 0, 0, $dateParts[1], $dateParts[0], $dateParts[2]));
echo $mysqlDate;