Re: PHP modifying data from DB?

Chris Shiflett wrote:

--- Gabe <ydnahg-news4432@mailblocks.com> wrote:

Here's what I tried and it seems to be working now. Thanks Richard! $var = date("m-d-Y", strtotime($dbDate)); $var then has the value of the date only. Still curious as to why those extra zero's are tacked on.

It's because MySQL is storing the date accurate to the second. Are you assuming the time is not stored, because you do a select at the MySQL prompt and don't see it? If so, that's the misunderstanding. Hope that helps. Chris ===== Chris Shiflett - http://shiflett.org/ PHP Security - O'Reilly

     Coming Fall 2004

HTTP Developer's Handbook - Sams

     http://httphandbook.org/

PHP Community Site

     http://phpcommunity.org/

Actually the date is being stored in an Access DB. The format for the field in the database is mm/dd/yyyy and yet I still get those extra zero's. Weird....