date format

[Woodburn2006]

if i have a date stored in my DB as 11/09/2007

 

is there anyway i can change it to 11th Sep once i have pulled it from the DB?

[Jessica]

You'll need to use date() and strtotime()

[Woodburn2006]

i tried:

$date = 11/09/2007;

$date = date('jS M', $date);

 

and for some reason it came out as '31st Dec' which is the right format but wrong date

[Jessica]

You only used one of the functions I said.

[Woodburn2006]

ok cool, my mistake

 

           

$date = 11/09/2007;
             $date = strtotime("$date");
$date = date('jS M', $date);

 

that works fine except the fact that it is reading it as an american date, but it is in a british date

so it is reading it as if its 9th Nov instead of 11th Sep

[Jessica]

Ah. Well if you know it will always be the british date, you could use substr() to take the day and month numbers and switch them. If you can't figure out how to do that post again and I'll post it for you.

[Woodburn2006]

ah sweet, i done it. used this:

 

$day = substr("$date", 0, -;
$month = substr("$date", 3, -5);
$year = substr ("$date", -4);
$date = "$month/$day/$year";
$date = strtotime("$date");
$date = date('jS M', $date);

 

dont know if thats the long way round but it works?

 

thanks

[Jessica]

That's how I'd do it.

[Dragen]

wouldn't this be easier:

list($d, $m, $y) = explode('/', $date);
$date = strtotime("$m/$d/$y");
$date = date('jS M', $date);

 

Just a bit shorter, but should work as well

[Jessica]

Great idea Dragen.

[Woodburn2006]

ideal, thanks alot

[Dragen]

no problem