[thelist] timestamp in mySQL
M.G. Noriega
manuel at simplelogica.net
Mon Jul 28 06:30:52 CDT 2003
El lun, 28-07-2003 a las 13:08, Alexis, Winston Design escribió:
> Hi all,
> I have a table in my mysql database with a timestamp column. The
> format for the timestamp is 20030728123921 wich doesn't seem to be the
> same referred to in the PHP manual when referred to Unix timestamp.
> Is there a function to convert my mySQL timestamp to i.e. Monday the
> 28th of July or should I change it all to the Unix timestamp used in
> the PHP manual?
>
> I'm running MySql 4.0.11 and PHP 4.3 on Mac OS X
>
> Peace,
> alexis
>
oops, my previous message was wrong in that the select will return the
unixtimestamp, you can format that to suit your tastes with php's date()
--
Manuel González Noriega
Simplelógica, construcción web @ http://simplelogica.net
Logicola es el weblog de Simplelógica http://simplelogica.net/logicola/
More information about the thelist
mailing list