PHP convert date to MySQL format

[Zaggs]

Hi Guys,

How do I convert a date in mmddyy format (ie: 251207) into a MySQL timestamp in following format: 2008-12-25 00:00:00

The main thing is that the date gets converted like above, I am not concerned about the time.

Thanks in advance.

[wonshikee]

str_split

[Zaggs]

str_split

Unfortunately I don't have PHP 5 installed

[felgall]

explode

[catweasel]

Hi Guys,

How do I convert a date in mmddyy format (ie: 251207) into a MySQL timestamp in following format: 2008-12-25 00:00:00

The main thing is that the date gets converted like above, I am not concerned about the time.

Thanks in advance.

If you are certain the date will always be in that format you could do -

<?php
$dte    = '251208';

$day    = $dte[0].$dte[1];
$mnth   = $dte[2].$dte[3];
$yr     = $dte[4].$dte[5];

printf("20%s-%s-%s 00:00:00",$yr,$mnth,$day);
?>

Where is the date coming from? User input?
Is the ddmmyy date actually used in the script logic? Could you just use mysql's date time functions to generate a correctly formatted date in the first place?

[Zaggs]

Hi,

Instead of using printf to show the output, how do I save the output as a variable?

[Hammer65]

Hi,

Instead of using printf to show the output, how do I save the output as a variable?

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

[Raju Gautam]

How about like this?

$string = "251207";
$date = "20" . substr($string, 4, 2) .
        "-" .  substr($string, 2, 2) .
        "-" .  substr($string, 0, 2);
$date = date('Y-m-d H:i:s', strtotime("$date"));
echo $date; 

[catweasel]

Hi,

Instead of using printf to show the output, how do I save the output as a variable?

Use sprintf -

$output = sprintf("20%s-%s-%s 00:00:00",$yr,$mnth,$day); 

Or use Hammer's suggestion, or Rajug's.. there's a million different ways to do this but I'm interested in knowing why are you receiving dates in the ddmmyy format without any delimeters?