Date Display Options

[Anon]

I am pulling dates from a MySQL database and populating a table. In the Date column, it currently echos like:

2002-01-28
2002-01-29
2002-04-23
2002-04-24

This is fine, but I would like to have it echo:

Mon, Jan 28
Tue, Jan 29
Tue, Apr 23
Wed, Apr 24

I am calling it like this:

$result = mysql_query ("SELECT * FROM Training_Dates ORDER BY Date");

print ("<table>");
if ($row = mysql_fetch_array($result)) {

do {

print ("<tr><td><font face=arial size=2>");
print $row["Date"];

and I need to know how to manipulate the $row["Date"] variable to display as above.

Any ideas?

[[deleted]]

read the mysql manual about the date_format() function

http://www.mysql.com/doc/D/a/Date_and_time_functions.html

---

A forum, a FAQ, email notification, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

[Anon]

This is one way to do it:

$dt = explode('-', $row["Date"]);
$date_mktime = mktime(0,0,0, dt[2],dt[1],dt[0]);

echo date('D, M j', $date_mktime);

hope this helps
Brian

[[deleted]]

A valiant try, but the manual has better methods :-)

[Anon]

Alright then,

How do I apply the genius of the manual to this code? The only help the MySQL manual gives is to use:

SELECT DATE_FORMAT('2002-04-24', '%W %M %e');

which will supposedly return "Wednesday April 24"

Great, but how do you write the query?! How do you apply this to the $row[Date] field?

$result = mysql_query ("SELECT * FROM Training_Dates ORDER BY Date");

print ("<table>");
if ($row = mysql_fetch_array($result)) {

do {

print ("<tr><td>");
print $row["Date"];
print ("</td></tr>"};
} while($row = mysql_fetch_array($result));
print ("</table>");

[Anon]

You can do this either with php or with MySQL during the quesry.

I prefer doing it in the query.

Here's an example:

SELECT date, date_format(date, '%b %e, %Y') as date ORDER BY 'date' ASC;

You date_format the field date and give the result a name (I used date here). Then just output it in your code e.g.

$date = $record["date"];

Choose the date format you want from the MYSQL manual. This example gives (as I remember):
Apr 24, 2002

Hope this helps

jonb

[Anon]

Hehee, that's one of the reasons why SELECT * is generally not a Good Thing. You should SELECT the fields you actually want to use.

SELECT DATE_FORMAT(Date,'%W %M %e') as Date, and, other, fields FROM Training_Dates ORDER BY Date

I haven't bothered to read the manual and even I can figure that out.