You want a TIMESTAMP column, not INT. See <http://www.mysql.com/doc/en/DATETIME.html>.
Michael
Keith Bussey wrote:
Hi all,
I was wondering if it is possible to have the default value of an integer field be the current UNIX timestamp ?
MySQL doesn't allow me to use .... not null default UNIX_TIMESTAMP() .....
If anyone knows a way of achieving this, it would be great =)
Also, I currently use "int(10) unsigned not null default 0" for my unix timestamp fields, is there perhaps a more efficient field type I should be using?
Thx
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
