> I am pulling from a datetime field in mysql.  The actual data looks like
> this: 2002-11-30 00:00:00  When I output the data to the page, I want it
> appear as 11/30/2002.  I want to use a php date format.  I do not want it
> formatted as it comes out of the db. But date("m/d/y", $myrow[departdate])
> returns 12/31/69.  How can I do this?

You have to convert the mysql date into a unix timestamp in order for it to
be used with date. You can do it in your query by selecting
UNIX_TIMESTAMP(your_column) and using what you have above, or you can try
the following with the query you already have.


---John Holmes...

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to