If you are a storing timestamps, you should use MySQL timestamp type, and
definitely not a varchar, as it would just waste space. Timestamps are stored as
efficiently as they could possibly be - a 4-byte integer, and you can do date
arithmetic on them with DATE_ADD() and DATE_SUB() functions. If you need the raw
seconds since epoch value use UNIX_TIMESTAMP(). To get it to go the other way,
do FROM_UNIXTIME()
--
Sasha Pachev
Create online surveys at http://www.surveyz.com/
____________________
BYU Unix Users Group
http://uug.byu.edu/
___________________________________________________________________
List Info: http://uug.byu.edu/cgi-bin/mailman/listinfo/uug-list
