i want to get only date from datetime variable in php

Question

I need to get only date from datetime variable. I was using this code. It was working fine but now I am facing problem when I'm trying to store only date in mysql please. Take a look at the code below and please tell me what I'm missing,

$date_time = "11-Dec-13 8:05:44 AM" 

From the date I got from user input, I need to save only date in att_date variable.

$arr = explode("/", $date_time);
$arr2 = explode(" ", $arr[2]);
$att_date = $arr2[0].'-'.$arr[0].'-'.$arr[1];

Answer 1

Here is the solution:

$date_time = "11-Dec-13 8:05:44 AM";
$new_date = date("Y-m-d H:i:s",strtotime($date_time));