Date Formatting in PHP

[hitesh_kapadia]

Hello,

I have date control fields on the screen. This control takes the format of mm/dd/yyyy on the screen. But if I try to save in MySQL table with this date format, it puts NULL value in the date field. So I need to convert the format from mm/dd/yyyy to yyyy/mm/dd (which is the format of the database date field). I am not able to convert the format of the date in PHP. I also tried to do the same in the MySQL query. That is not working either.

Can anybody help?

Thanks
Hitesh

[dalecosp]

$datestr="08/24/2005";
$sqlstr=date("Y/m/d",strtotime($datestr));