Date Formatting

space1

I'm trying to take the date stored in MySql database and then turn it into individual parts of a date. For example, I want one variable to just hold the month (ex: $sMonth = 'Feb'). However when I try to retrieve the month from the Start Date (2003-02-02 05:33:00), it gives me incorrect data.

What am I doing wrong?

$row['StartDate]; *This is the StartDate that is retrieved from my database:
2003-02-02 05:33:00

I've tried this but it doesn't work:
$date_array = explode("-", $row['StartDate']);
echo "Month=" . $date_array[0];

I've tried this and it gives me "Dec" instead of "Feb"
$sMonth = date("M", $sStartDate);

Thanks for your help!!
Andrea

YappyDog

Looks like you're using the wrong array piece after your explode

echo $date_array[0]; // this should be the year - 2003

Use $date_array[1] to get to the month.

space1

Oh you're right..duh..thank you!

One more question using explode (), I can get the month, day and year. But then, how do I get the hour, minutes and seconds since you can't explode them with a "-"

Also the hour and the day turn into one since the expode using a "-" includes the hour data too.

Thanks for your help!

YappyDog

I guess I'd be more inclined to use the strtotime() function to convert your date/time string into the internal format. Then you can use the date() function to get it back in any format or pieces you want.

http://us2.php.net/manual/en/function.strtotime.php

http://us2.php.net/manual/en/function.date.php