Re: help with date formatting
| From: | Mark Heintz PHP Mailing Lists | Date: | Mon, 18 Mar 2002 18:02:36 +0000 |
| Subject: | Re: help with date formatting | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-88968@lists.php.net to get a copy of this message | ||
Since you're using phpmyadmin, I'm assuming you're using mysql. You could
use the built-in date and time functions to do the formatting when
selecting your date field. Check here:
http://www.mysql.com/doc/D/a/Date_and_time_functions.html
mh.
On Mon, 18 Mar 2002, Ryan wrote:
> 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