[Resolved] format date() help

[Paul_Ferrie]

Hi guys.

I am trying to format the date returned from a query. I think i am overlooking something simple.

in the db i have a table:admin
username, uservisit etc...
uservisit is a date() colum
This returns year/m/d as 2005/02/26
This is fine
But i want to display the lettering instead on the numeric
So it would be something like "Saturday 26 Febuary 2005"
How do i format the date returned?
i did try

$lastVisit= date($userDetails["admVisit, '$d %D %M %Y'"]);

It just returns empty.

Thanks
Paul

[dalecosp]

$st="2005/02/26";
echo date("l d F Y", strtotime($st));

HTH,

[chucklarge]

you can use the DATE_FORMAT command in your database query and have the date formated there. forexample

$result = mysql_query("SELECT DATE_FORMAT(date, '%b %d %Y') AS dateformated FROM table ORDER BY date DESC") or die(mysql_error());
while ($row = mysql_fetch_assoc ($result))
		{	echo $row['dateformated'];
		}
  

I really like this approach because you can use/print the formated date but order it by the date. I guess that is only relevant if you have the datatype as datetime like i do.

[Paul_Ferrie]

Thanks guys got it sorted 🙂🙂

$lastVisit = $userDetails['admVisit'];
$lastVisit = date("l d F Y", strtotime($lastVisit));

print "&retval=1&lastVisit=$lastVisit";