Splitting a Date

[Anon]

Hi,

Does anybody know how to split a date that is taken from a MySQL database in PHP?

Basically the date is in the format DD MM YYYY when taken from the database. how can i split this up just to $Day = Dd, $Month = $MM and $Year = YYYY

Any ideas anybody?

I tried using the substr() but it won't wokr for some reason.

Thanks in advance

[skripty]

you could try splitting it into an array...
$date = explode(" ",$date);

Then the day would be $date[0]
The month would be $date[1]
And the year would be $date[2]

Hope this helps

[metin]

This may be of help:
<?php
$date = '2002-07-23';
$time_stamp = strtotime($date);

$day = date("d",$time_stamp);
$month = date("m",$time_stamp);
$year = date("Y",$time_stamp);
echo $day."<br>";
echo $month."<br>";
echo $year."<br>";
?>