[RESOLVED] Break appart variable??

Hi there, in a database i have a date column, from witch a date is read.
2005-09-08
YYYY-MM-DD

I would like to break it into:

$date=(red from  database)
$year=(2005)
$month=(09)
$day=08)

Is this possible?
Thank you for your time
~Gabor

$your_date = "2005-01-12";
$date_array = explode ("-", $your_date);

That should break it into an array for you

You can do a one-liner:

list($year, $month, $day) = explode('-', $date);

Is this possible?

Here are a couple more possibilities:

$query = "SELECT YEAR(date_field) as yr,
                 MONTH(date_field) as mon,
                 DAY(date_field) as dy
          FROM my_table";

or:

$date = strtotime($row['date_field']);
$year = date('Y', $date);
$month = date('m', $date);
$day = date('d', $date);

Myself, though, I'd go with Revraz's for an array or NogDog's for scalars.