In PHP you could do something like:

$mydate = date("l, F jS, Y", strtotime($row["eventdate"]));
echo $mydate; gives a full listing of possible 
formatting options.

Nicole Swan
Web Programming Specialist
Carroll College CCIT

-----Original Message-----
From: Justin @ Dreaming in TO [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 20, 2004 12:28 PM
Subject: [PHP-DB] Displaying Date from Value in MySQL DB

Hey All,

Looking to try to figure at small problem.

This is the SQL query I am using to show the next event on a page:

SELECT ditoevents.eventstatus, ditoevents.eventdate, 
DATE_FORMAT(ditoevents.eventdate, '%a, %b %d %Y'), ditoevents.eventtime, 
ditoevents.eventlocation, ditoevents.topic, ditoevents.presenter
FROM ditoevents
WHERE ditoevents.eventstatus = 'next'

This is the structure of the table in the MySQL db:

CREATE TABLE ditoevents (
   ID char(3) NOT NULL default '',
   eventID char(2) NOT NULL default '',
   eventstatus varchar(4) NOT NULL default '',
   eventdate date NOT NULL default '0000-00-00',
   eventtime time NOT NULL default '00:00:00',
   eventlocation text NOT NULL,
   topic text NOT NULL,
   presenter text NOT NULL

The problem is, the date value that's being pulled from the DB is being 
displayed as 2004-05-12. I would like the date to be displayed as, 
Wednesday, May 12th, 2004.

How do I do this with PHP. I looked at some of the date functions, and 
I'm a bit confused.



PHP Database Mailing List (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to