RE: [PHP-DB] Displaying Date from Value in MySQL DB

2004-04-20 Thread Michael Scappa
r Replogle [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 20, 2004 5:36 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [PHP-DB] Displaying Date from Value in MySQL DB You could always make your own function. If you need help with that i would be glad to help there too. >From: "Justi

RE: [PHP-DB] Displaying Date from Value in MySQL DB

2004-04-20 Thread Swan, Nicole
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 C

RE: [PHP-DB] Displaying Date from Value in MySQL DB

2004-04-20 Thread Tyler Replogle
You could always make your own function. If you need help with that i would be glad to help there too. From: "Justin @ Dreaming in TO" <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] Subject: [PHP-DB] Displaying Date from Value in MySQL DB Date: Tue, 20 Apr 2004 14:27:30 -0400 Hey All, Looking to tr

Re: [PHP-DB] Displaying Date from Value in MySQL DB

2004-04-20 Thread John W. Holmes
From: "Justin @ Dreaming in TO" <[EMAIL PROTECTED]> > 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