Date conversion, quick question :).

[virtuexru]

Hey everyone,

 

I just wanted to know what your best approach would be to my problem.

 

I have a date in this format:

 

1/27/09

 

I need to be able to convert it into this format:

 

2009-01-27

 

Anyone got any ideas?

[flyhoney]

echo date('Y-m-d', strtotime('1/27/09'));

[tqla]

I need to do the same thing but this aint working for me. PHP is confusing the month with the date.

 

<?php 
$mysqlFormat = "12-01-2010"; // Dec 1, 2010
echo date('Y-m-d', strtotime("$mysqlFormat"));
?>

 

This is echoing 2010-01-12 which is wrong! This means Jan 12, 2010.

 

How can I fix this?

[genericnumber1]

<?php
$format = explode('/', '1/27/09');
echo date('Y-m-d', mktime(0, 0, 0, $format[0], $format[1], $format[2]));

 

to be sure it knows exactly what the month/day/year is.

[tqla]

Ah ha, Thanks genericnumber1! That works. This ain't my ticket so I can't close it.