From: | JT Kirkpatrick <jt-kirkpatrick(at)mpsllc(dot)com> |
---|---|
To: | "'nmmm(at)nsi(dot)bg'" <nmmm(at)nsi(dot)bg> |
Cc: | "'pgsql-sql(at)hub(dot)org'" <pgsql-sql(at)hub(dot)org> |
Subject: | |
Date: | 1999-07-13 12:39:50 |
Message-ID: | 01BECD0B.45F87E00.jt-kirkpatrick@mpsllc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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(at)nsi(dot)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
------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | D'Arcy J.M. Cain | 1999-07-13 12:52:49 | Re: [SQL] calculating percentages |
Previous Message | Patrik Kudo | 1999-07-13 12:15:40 | "quoting" column names |