Re: Re: help with date formatting

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 <SpanglerRP22@uww.edu> 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 SpanglerRP22@uww.edu -- Ryan Spangler 428 N Harmony Ln, Apt. 3 Whitewater, WI 53190 (262) 473-8392 SpanglerRP22@uww.edu -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php