formating date

[Anon]

Right now I have a database that has the date in the format mmddyy(071702). I need to break it apart into the month, day and year and then get the month to display as a word. The day is done after the split and the year I just have to add 2000 to it but the month is a little more confusing. Thanks

[john_locus]

Maybe you wanted a smarter sollution, but what I would do is build a switch for it. example:

$monthname = "";
switch ($month) {
case "01":
$monthname = "january";
break;
case ........

}

hope this helps

[anorakgirl]

something like:

$month=number_format(07);

(where 07 is the month part of the date string, do this to remove the leading 0)

$months = array("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");

$monthtext=$months[$month - 1]

hope that helps...

[Anon]

How do I split the rest up though to get the day and year from 071702. like this

$month=first 2 numbers
$day=second 2 numbers
$year=last 2 numbers

[anorakgirl]

try the substr function - see the php manual for details.

$dt = "071702";
$month = substr($dt,0,2)
etc