Re: PHP modifying data from DB?

--- 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/