Received: from photon.skillbrokers.bg (root@[195.24.42.194]) by hub.org (8.9.3/8.9.3) with ESMTP id EAA16112 for ; Mon, 12 Jul 1999 04:28:31 -0400 (EDT) (envelope-from nmmm@nsi.bg) Received: from niki (proton.skillbrokers.bg [195.24.42.206]) by photon.skillbrokers.bg (8.9.0/8.9.0) with SMTP id LAA08722 for ; Mon, 12 Jul 1999 11:26:04 +0300 Message-ID: <001001becc3f$7e2962c0$ce2a18c3@skillbrokers.bg> From: "Nikolay Mijaylov" To: Subject: Stupid question about default time value Date: Mon, 12 Jul 1999 11:21:02 +0300 MIME-Version: 1.0 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 I made a table such as: create teble x( i int2, d date default 'today', t time default 'now', dt datetime default 'now' ); So these default values are not working as i think... they make the default values to be equal to time when table was created.... i fixed problem in this way: create teble x( i int2, d date default date( now() ), // or now() :: date t time default datetime_time(datetime (now ()) ), dt datetime default now() ); is there better way to do this????? Niki w3.nsi.bg/nmmm www.nsi.bg/nmmm nmmm.hypermart.net ????? thanx