[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: ? $conftime = mktime($hour, $minute, $seconds, $month, $day, $year); echo date(l, F jS, Y, $conftime); ? -- 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
[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
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