08-22-2008, 01:28 PM
|
#2 (permalink)
|
|
The Contributor
Join Date: Jan 2008
Location: Maine, USA
Posts: 92
Thanks: 2
|
It looks like a data type issue. Take a look at the docs for MySQL's TIMESTAMP datatype.
Quote:
|
TIMESTAMP columns are displayed in the same format as DATETIME columns. In other words, the display width is fixed at 19 characters, and the format is 'YYYY-MM-DD HH:MM:SS'
|
I typically store unix timestamps as an INT.
__________________
-- Bill
"Why is it drug addicts and computer aficionados are both called users?" -Clifford Stoll
|
|
|
|