[thelist] timestamp in mySQL
M.G. Noriega
manuel at simplelogica.net
Mon Jul 28 06:28:12 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?
>
SELECT UNIX_TIMESTAMP(mytimestampcolum) should work
--
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