[snip] > The column type needs to be DATETIME. Thank you for pointing me at TIMESTAMP versus DATETIME. I'll read <http://dev.mysql.com/doc/refman/4.1/en/date-and-time-types.html> thoroughly when I can.
Can you give a little more detail as to why DATETIME is necessary? [/snip] It was much too quick a reply on my part but it is my understanding that a TIMESTAMP field is updated according to server time and you cannot actually insert a value. I may be wrong as I have never tested this. On the other hand a DATETIME field accepts inserts. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]