probably easy to do but...

Anon

I have a drop down field that retrieves a date from a database in the YYYY-MM-DD format.

After I get the date, I want to post process it into textual format:

Day, Month, Year

So the end result would be similar to this:

while ($row = mysql_fetch_array($sql_result)) {
$date1 = $row["date"];
echo "<option value=\"$date1\">$date2</option>";

Where $date1 is the YYYY-MM-DD format, and $date2 is the textual version.

Is this easily done?

Anon

I think you could use explode() :
$array_date = explode("-", $date1);
$day = $array_date[2];
$month = $array_date[1];
$year = $array_date[0];

Anon

this is actually pretty easy to do. it does require some code, but it is not hard to understand. simply use the date you recieve from your database info as the second param in your date function. Since you want it in "l, F, Y" format you have to do this:

get day, month, year seperate:

$dday = substr($date1, 8, 2);
$dmonth = substr($date1, 5, 2);
$dyear = substr($date1, 0, 4);

now you need to convert that into a timestamp using mktime. since you dont know the time and just the date you need to leave the first 3 elements of mktime blank:

$date1 = mktime("","","",$dmonth,$dday,$dyear);
$date2 = date("l, F, Y", $date1);

that should set $date2 equal to what you want.

Anon

this separates the date, but does not convert it to textual format. And upon reflection, I only need the month set to textual...

July 18, 2002

Anon

i misunderstood what you want you would want the first param of the date function to look like this:

"F dS, Y"

which would produce something like:

July 18th, 2002

slug58

give this a try:

<?php

$timestmp = strtotime("2002-07-19");

$datestr = date("D F Y", $timestmp);

print "date 2002-07-19 : $datestr";

it should do the trick!!

and you can get more Date/Time info here:
http://www.phpbuilder.com/manual/ref.datetime.php

Anon

rock! this was enough to get me going! Thanks for yuor help!

Anon

Well, you just have to create an array containing months names !

$months_names = array("january", "february", ....................................., "december");
$array_date = explode("-", $date1);
$day = $array_date[2];
$month = $array_date[1];
$year = $array_date[0];
$month = $months_names($month - 1);

Anon

heh, yeah forgot about that one... good call.

Anon

or you could set the date format in the query.. i did this the other day....

$query = "SELECT date_format(date, '%M %e') FROM table order by date asc";

$result = mysql_query($query);

while($query_data = mysql_fetch_array($result)) {
$date = $query_data["date"];
}

That query then retrieves a yyyy-mm-dd date field and turns it into e.g. 17th July format!!!