Re: [PHP] 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 <[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
[PHP] Re: help with date formatting
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] Re: help with date formatting
"Ryan" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > 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. > If you are using the mktime() to make a UNIX timestamp you could do something like this: -- Joshua E Minnie CIO [EMAIL PROTECTED] "Don't work for recognition, but always do work worthy of recognition." -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
