I have a form field ('date') that stores the date in a table as : '02-19-2006'
(These are future calendar dates that make up an "Upcoming Events" page...)
I need to display it on the output page as: 'Saturday February 19, 2006'
but still want to sort the query output using 'ORDER BY 'date'
how to?
Thanks in advance.
mc
Formatting the way a stored date displays...
Moderator: General Moderators
Code: Select all
$date = $row['date'];
$timestamp = strtotime($date);
$newDate = date($timestamp,"date format string here");Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.