使用日期函数以mysql日期格式格式化日期

Question

i am trying to pass date to mysql query using php, but i am not getting what i want

my php statement is like that

$date_s="01/03/2012";
$date_s=date("YYYY-MM-DD", $date_s);
echo $date_s;

its printing 1970197019701970-JanJan-ThuThu

what i want is to format above date from 01/03/2012 to 2012-03-01

i know its little thing to format the date but i am not figuring out what to do, i have tried all possible functions and formatting?

Answer 1

Try this

$date_s="01/03/2012";
$date_s=date("Y-m-d", strtotime($date_s));
echo $date_s;