In PHP you could do something like:
$mydate = date("l, F jS, Y", strtotime($row["eventdate"]));
echo $mydate;
http://us4.php.net/manual/en/function.date.php gives a full listing of possible formatting options.
--Nicole
---------------------------
Nicole Swan
Web Programming Specialist
Carroll College CCIT
(406)447-4310
-----Original Message-----
From: Justin @ Dreaming in TO [mailto:justin@xxxxxxxxxxxxxxxx]
Sent: Tuesday, April 20, 2004 12:28 PM
To: php-db@xxxxxxxxxxxxx
Subject: 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
) TYPE=MyISAM;
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.
Thanks,
Justin
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
