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" <holmes072000@xxxxxxxxxxx> wrote in message
news:419CD78D.2030907@xxxxxxxxxxxxxx
> 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
