on 9/27/03 7:55 PM, PeterWR at [EMAIL PROTECTED] wrote: > Hi, > > I dont think so - the timestamp is a system-field, set by the system and can > not be modifyed by users. > > You probably have to make an additional datetime-field for You purpose - if > You can do CONCAT(timestamp + NOW()) when it is INSERT, I dont know - try.
I hope this is not the case, I have been update table set updated = NOW() for most all my datbases, seems to insert a 14 character timestamp reliably. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 http://www.newgeo.com Fax: 313.557.5052 [EMAIL PROTECTED] Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]