I always use the mySQL DATE_FORMAT function in my queries themselves...
SELECT DATE_FORMAT( someDatField, "%m/%d/%Y" ) as thedate FROM someTable At 12:23 PM 3/18/2002 -0600, Ryan wrote: >On Mon, 18 Mar 2002 11:51:07 -0600 >Ryan <[EMAIL PROTECTED]> wrote: > >By, the way I'm getting the date from a MySQL database. The posted date >variable is stored as the date type in the MySQL database so it comes >out like this 2002-03-06. Should I convert the date into a time stamp >or how should I do this. Let me know what would be the most efficient >and best way to do this. Thanks. > > > > > Hi, I'm trying to create an events page, where it shows the posted > > events. I enter data using phpmyadmin. Currently, the ouput is like > > this: > > > > -------------------------------------------------------- > > Conference in New York > > 2002-03-06 > > > > There is going to be a conference in New York next week. > > -------------------------------------------------------- > > > > I'm having trouble with the formatting of the date. I'm using the > > type date with the function now, so it shows the current date when I > > post an event. Here is what I would like: > > > > -------------------------------------------------------- > > Conference in New York > > Wednesday, March 5th, 2002 > > > > There is going to be a conference in New York next week. > > -------------------------------------------------------- > > > > Thanks for any help. > > > > -- > > Ryan Spangler > > 428 N Harmony Ln, Apt. 3 > > Whitewater, WI 53190 > > (262) 473-8392 > > [EMAIL PROTECTED] > > >-- >Ryan Spangler >428 N Harmony Ln, Apt. 3 >Whitewater, WI 53190 >(262) 473-8392 >[EMAIL PROTECTED] > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
