At 11:25 +0900 1/8/04, Dave G wrote:
Paul,

>(Unix timestamps are ten digits, aren't they?). No, they're fourteen digits: CCYYMMDDhhmmss

I think we might be talking about different things. A UNIX time stamp is ten digits long: http://www.unixtimestamp.com/ How MySQL stores it's own TIMESTAMP column is the format you describe.

I want to know if there's any problem storing a UNIX timestamp purely as
an integer in my MySQL database.

I think not, as long as you don't treat it like a TIMESTAMP column.



-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com

MySQL Users Conference: April 14-16, 2004
http://www.mysql.com/uc2004/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to