Re: format date field
| From: | Kevin Murphy | Date: | Wed, 23 May 2007 17:26:23 +0000 |
| Subject: | Re: format date field | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-255445@lists.php.net to get a copy of this message | ||
Leave the date as is, its a MySQL thing. To format it on your page, use the date function:
$formattedDate = date("m-d-Y",strtotime($row["open"]));
http://us2.php.net/manual/en/function.date.php
--
Kevin Murphy
Webmaster: Information and Marketing Services
Western Nevada Community College
www.wncc.edu
775-445-3326
On May 23, 2007, at 9:45 AM, Mike Ryan wrote:
> I am reading in a date field from a mysql database the field on the
> screen
> shows up as 2007-05-01 on the screen I would like the field to show
> 05-01-2007 currently I am issueing the following command print
> $row['open']; how can I format this field???
>
> while I am at it how can I accept the date field as 05-01-2007;
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>