date problems

[trojan_ted]

What i need to do is retrieve a date from a mysql table and break it down into dd mm and yyyy

in the mysql table its in standard format yyyy-mm-dd

and i understand the concept of re-formatting the date in the query

SELECT DATE_FORMAT(column_name, '%d %m %y') FROM table

how do i then work with just the dd or mm parts of the date?

[nnichols]

it depends on what you want to do with it. You could select the various different parts of the date in different cols -

SELECT YEAR(col_name) AS Y, MONTH(col_name) AS M, DAYOFMONTH(col_name) AS D FROM tbl

Or having retrieved the complete date column you could split it into an array with explode -

// YYYY-MM-DD
$date = '2003-01-05';
$date = explode('-', $date);

echo $date[0];
// returns 2003

echo $date[1];
// returns 01

echo $date[2];
// returns 05

Hope this helps 😉

[cgraz]

Hmm, the easiest way would be to just select the %m and %d and leave out the %y, but you probably need the %y for something else. That outputs as 04 01 02, right? You could just use the first 5 characters (dd[space]mm).

Assuming you put the results in an array called $row, what you might try is

$date_column = substr($row["column_name"], 0, 5);

now $date_column holds the day and month. Note i grabbed the first 5 characters because there will be a space between the day and the month.

Cgraz

[trojan_ted]

Thanks yet again guys!

I would surely be sunk without this forum😃