{Problem} How to display date?

[csj]

Im fairly new to PHP, but im pretty certain this is probably an easy problem. If it is then I apologise in Advance.

I have a date saved in a database in the 2007-02-07 Format

What I want to do is retrieve this from the database, but somehow break it up so that each part of the date becomes its own single variable.

For example...

$Year = "2007";
$Month = "02";
$Day = "07";

I hope I have made this clear. I would really appreciate some help.

[Raffles]

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

That should do it.

[jestep]

There are a few ways to do it.

The easiest that I can see is to split it into an array and use it however you need. This method would work best as long as it is always in this format.

$date = date_from_mysql_query;

$date = split('-',$date);

$year = $date[0];
$month = $date[1];
$day = $date[2]; 

You can also convert it to a date and display it using php. The strtotime() in conjunction with the date() function should be able to help you out put it this way.

[csj]

Thanks a milllion!! I will try those out.

[Raffles]

split() and explode() are the same thing, in case you wonder.

[stereofrog]

not really, in case you care

print_r(split('.', "aa.bb.cc"));
print_r(explode('.', "aa.bb.cc")); 

[siteguru]

Interesting!

[Raffles]

Fair enough. These are the same then:

print_r(split('[.]', "aa.bb.cc"));
print_r(explode('.', "aa.bb.cc")); 

But explode is faster and it sounds cooler.

[trib4lmaniac]

Fair enough. These are the same then:

print_r(split('[.]', "aa.bb.cc"));
print_r(explode('.', "aa.bb.cc")); 

But explode is faster and it sounds cooler.

Save a character!

print_r(split('\.', "aa.bb.cc"));
print_r(explode('.', "aa.bb.cc")); 

Not that you should use split for something so simple anyway.