|
|
Posted by Alan on 08/29/06 18:36
On 29 Aug 2006 11:25:37 -0700, Sloane T. Irwin wrote...
>
>Hello,
>
>First of all I'd like to thank everyone who's helped me in the past
>with my php problems. I'm learning a ton aboput mySQL and php, but have
>come across a problem. In my table there is a timestamp field that
>lists it like YYYY-MM-DD HH:MM:SS when echoed..
>
>The time portion of this field is only neccessary when we need it
>specifically, and having it in the table all the time is making my
>formatting very messy. Is there a way to return only the first 10
>digits of the timestamp so that it only displays the date? That's all
>that's really necessary for the main table display.
>Any help would be greatly appreciated
>
>Sloane
>
Found a help page at a MySQL site that might offer smoothing useful...
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
The "SELECT DATE_FORMAT()" function might be what you're looking for.
Alan
--
Newsguy Help A Community Program
http://newsguy.com/charity.asp
Navigation:
[Reply to this message]
|