Re: format date field
| From: | itoctopus | Date: | Wed, 23 May 2007 22:05:57 +0000 |
| Subject: | Re: format date field | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-255473@lists.php.net to get a copy of this message | ||
SELECT DATE_FORMAT('open', '%m-%d-%Y') FROM your_table_name;
--
itoctopus - http://www.itoctopus.com
""Mike Ryan"" <miker@mail.manti.com> wrote in message
news:42.A3.45184.F9F64564@pb1.pair.com...
>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;