date question

joseph_adams1

Hi all,

I have a database field of the type date. As I understand it, it will store the date in the format 2003-09-01 (Y-M-D), what I would like to know is this:

Is there a quick and easy way to take that date and to split it into component parts?

I think I remember reading about an explode() function that may do the trick, but am not sure.

Tried to use the explode() function by doing this;


explode("-", $Date_From);

echo "</table>";
echo $Date_From[1];
echo "<BR>";
echo $Date_From[2];
echo "<BR>";
echo $Date_From[3];
echo "<BR>";
echo $Date_From;

The result I got was this:

3
2003-09-01

Can anyone explain what's going on?

😕

bad76

Hi,
explode() don't change the source, but make a brand new array:

$Date_From=explode("-", $Date_From); 

echo $Date_From[0]; // start with 0, not 1
echo "<BR>"; 
echo $Date_From[1]; 
echo "<BR>"; 
echo $Date_From[2]; 
echo "<BR>"; 
echo $Date_From;

This now will output

2003
09
01
Array

Spudgun

If you know that the date format will always be YYYY-MM-DD, you can use substr -

$year = substr($Date_From,0,4);
$month = substr($Date_From,5,2);
$day = substr($Date_From,8,2);

HTH

joseph_adams1

Got it working by doing this


list($holYear, $holMonth, $holDate) = explode('-', $Date_From);

That then stores the stuff in three new variables;

holYear
holMonth
holDate

Thanks for the help guys.