Ok, thanks for the input. I knew that was an option as well, the problem is that I have about eight different dates in the query, and I'd rather do a query like "SELECT projects.* FROM projects..." and then format those results, rather than do "SELECT DATE_FORMAT('%m %d %Y', projects.Date1) AS Date1, DATE_FORMAT('%m %d %Y', projects.Date2) AS Date2,... etc"
any other suggestions? "John Holmes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Doug Parker wrote: > > I'm trying to format a MySQL Timestamp Column Type with PHP, and it's not > > going well. In reading up on it, I see that the idea is to convert the > > Timestamp type to Unix format using the strtotime() function, then using the > > date() function to format that result. However, this only appears to work > > with MySQL versions above 4.1 - where the Timestamp has been modified to > > have the ":" symbol in between the approprate numbers, as opposed to the > > traditional extended format (i.e. 20041117104300), which can be found on > > Mysql versions 4.0xx and below. I have > MySQL 4.1 on my local machine, but > > MySQL 4.0 something on the box I'm publishing to - which is obviously the > > more important box. So I need to get it working using the regular format. > > And I don't want to just parse the characters because I have a bunch of > > timestamp columns and don't really think it's that great of a resolution. > > Use DATE_FORMAT() in your query to format the timestamp, TO_UNIXTIME() > to retrieve a unix timestamp instead of a MySQL timestamp in your query, > or use a couple substr() calls to pull out the pieces of the MySQL > timestamp you need and then pass them to mktime(). > > -- > > ---John Holmes... > > Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ > > php|architect: The Magazine for PHP Professionals – www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php