[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