[thelist] timestamp in mySQL

Alexis, Winston Design alexis at winstondesign.se
Mon Jul 28 06:08:53 CDT 2003


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

--
Alexander Fellenius, Winston Design
Adress: Åsögatan 56, 4tr, SE-118 29 Sthlm
Tel: +46 (0)8-464 70 46 > Mobil: +46 (0)704-38 12 83
Webb: http://www.winstondesign.se


More information about the thelist mailing list