niki --
in the creation of your table, use ->dt datetime default text 'now'
i had the same problem as you and this cured it. . .
i believe also it works with the other data types. . .
jt kirkpatrick
++++++++++++++
Date: Mon, 12 Jul 1999 11:21:02 +0300
From: "Nikolay Mijaylov" <nmmm@nsi.bg>
Subject: Stupid question about default time value
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
------------------------------