Re: PHP modifying data from DB?
| From: | Richard Davey | Date: | Fri, 23 Apr 2004 18:23:47 +0000 |
| Subject: | Re: PHP modifying data from DB? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-184450@lists.php.net to get a copy of this message | ||
Hello Gabe,
Friday, April 23, 2004, 7:20:14 PM, you wrote:
G> However, when I retrieve the date from DB using PHP, it displays the
G> following:
G> 2004-04-08 00:00:00
G> Is PHP tacking on the zero's? I've tried using the date() function to
G> reformat it back to how I want it, but haven't gotten it to work.
You are probably using a datetime field in your database, as opposed
to a date field - which is where the extra zeros are coming from.
--
Best regards,
Richard Davey
http://www.phpcommunity.org/wiki/296.html