Received: from minbar.arcamax.com (host-10.arcamax.com [206.246.240.138]) by hub.org (8.8.8/8.8.8) with ESMTP id KAA09609 for ; Mon, 28 Sep 1998 10:50:44 -0400 (EDT) (envelope-from bryan@arcamax.com) Received: from bryan.arcamax.com (bryan [206.246.240.163]) by minbar.arcamax.com (8.8.7/8.8.7) with SMTP id KAA31885 for ; Mon, 28 Sep 1998 10:50:27 -0400 Message-ID: <00a401bdeaef$54d265c0$a3f0f6ce@bryan.arcamax.com> From: "Bryan White" To: Subject: Setting current time on insert Date: Mon, 28 Sep 1998 10:50:27 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 I have a table with a column defined as: Date timestamp not null default 'now' The intent was to set the field to the data/time the row was created. The result seems to be that 'now' is evaluated when the table is created and all records get this value. Is there a way to defer evaluation of the column default until a record is inserted? Bryan White ArcaMax Inc. Yorktown VA www.arcamax.com