Reverse Date from mySQL

[petenaylor]

Hi all

 

I have an SQL database that holds dates in this format: yymmdd example: 110824

 

I am echoing the value:

 

<?php echo $showdata['date']; ?>

 

How do I reverse the string so it shows 240811 ?

 

Cheers

Pete

[msaz87]

$date = date("dmy",strtotime($showdata['date']));

[petenaylor]

Thanks for your quick reply!

 

That just shows today's date instead of the date from the DB?

 

How should I echo out the $date?

 

Pete

[msaz87]

Thanks for your quick reply!

 

That just shows today's date instead of the date from the DB?

 

How should I echo out the $date?

 

Pete

 

It doesn't like the format of the date you're storing... I had to test it to make sure. Your two options are to store the date in a different way (e.g. YYYY-MM-DD) or you can use another solution like just rearranging the numbers in the string.

 

$first = substr($showdata['date'], 4, 2);
$second = substr($showdata['date'], 2, 2);
$third = substr($showdata['date'], 0, 2);

$newDate = $first.$second.$third;

[Pikachu2000]

You should really be storing the date in the correct format to begin with, but you can do what you're asking with MySQL's STR_TO_DATE() and DATE_FORMAT() functions as well, and it will probably be more efficient also.

 

SELECT DATE_FORMAT(STR_TO_DATE(`date`, '%y%m%e'), '%e%m%y') AS formatted_date FROM table