Dividing date type data to several parts

[Dakkar]

I have a date type mysql data(like 2004-09-29) but i want to divide it to several parts like year,month,date
how can i take this datas from mysql table and divide it to several parts?

[Shrike]

In MySQL with the DATE_FORMAT() function, in PHP with date() combined with strtotime().

[Dakkar]

but this is not the thing that i wanted i have a date type data in mysql (written with mysql now function like 2004-04-29)i want to take this data and divide into parts for example i want to take year part ?

[laserlight]

Method #1: Use substr() since the string is of fixed length.

Method #2: Use explode() to create an array of 3 elements.

[chriswheat]

Here is the code I wrote for my site. It uses $date as the var pulled from the db.

//START DATE CONVERSION--------------------------------------
//-- turns 2004-12-31 into seperate chunks ie:
//$year = 2004
//$month = 12
//$day = 31
$year = substr("$date", 0, 4);
$month = substr("$date", 5, 2);
$day = substr("$date", 8, 2);
//END DATE CONVERSION----------------------------------------

Thanks,
Chris

[Dakkar]

Thanks to everyone especially laserlight

[Shrike]

$r = mysql_query("SELECT DATE_FORMAT(datefield, '%Y') AS year, DATE_FORMAT(datefield, '%m') AS month, DATE_FORMAT(datefield, '%d') AS day, datefield FROM table");
$d = mysql_fetch_array($r);
// $d should contain:
// $d = array ("year" => 2004, "month" => 01, "day" => 01, "datefield" => "2004-01-01");
// You can also format a MySQL date field thus:
echo date("Y", strtotime($d['datefield']));
echo date("m", strtotime($d['datefield']));
echo date("d", strtotime($d['datefield']));

To illustrate both of the ways I suggested 🙂