[RESOLVED] date format into mySQL

[fasmy98]

I have an input text.
<input type="Text" id="demo2" maxlength="25" size="20" name="akhir">
<a href="javascript:NewCal('demo2','ddmmmyyyy',true,24)"><img src="image/cal.gif" width="16" height="16" border="0" alt="Pick a date"></a>

the output in the text box will be 23-Jun-2005

to insert into thw MySQL database I need to convert the date format to be YYYY-MM-DD
Can someone help me on this formatting.
😕

[bogu]

Convert the date into a unix timestamp using strtotime and after that format the date using date function ...

[cahva]

$date1 = '23-Jun-2005';
$date2 = date("Y-m-d",strtotime($date1)); // $date2 will be 2006-06-23