How to convert MM/DD/YYYY to YYYY-MM-DD?

Question

Hi all,

I have a jquery calendar that sets the input value to MM/DD/YYYY

How would I convert it so that my database column (date) can accept it correctly?

EDIT

Gordon was right - his link pointed me to this answer

$mysql_date = date('Y-m-d H:i:s', strtotime($user_date));

Answer 1

You want to do this in PHP, right?

1. Use Explode

   $christmas = "12/25/2010";
   $parts = explode('/',$christmas);
   $yyyy_mm_dd = $parts[2] . '-' . $parts[0] . '-' . $parts[1]
   

2. Use strptime to parse it to a timestamp and then strftime to format it the way you want it.

Answer 2

We need more information?

1) What script is inserting into database? I am assuming PHP

2) Also we need to know how you are storing the date and in what format?

My solution would be:

$dates = preg_split('/\//',$_POST['date']);

$month = $dates[0];
$day = $dates[1];
$year = $dates[2];

$finalDate = $year.'-'.$month.'-'.$day;

Answer 3

I will suggest to use strtotime() function and then date(). By this you can convert any format of date.

$unix_time_stamp = strtotime($mm_dd_yyyy);
$yyyy_mm_dd = date(Y/m/d,$unix_timestamp);

Answer 4

$date = "07/12/2010";
$your_date = date("Y-m-d", strtotime($date));

I hope my answer is useful :)

Answer 5

Alternatively you can do this without using the explode:

$date = "12/25/2010";
$mysql_date = date('Y-m-d', strtotime($date));

You can now use $mysql_date to insert into your database.

Answer 6

if you just want one line try this:

$time = "07/12/2010";

$new_time = preg_replace("!([01][0-9])/([0-9]{2})/([0-9]{4})!", "$3-$1-$2", $time);

var_dump($time);
var_dump($new_time);