[EMAIL PROTECTED] <[EMAIL PROTECTED]> schrieb:
>
>
> This issue always stumps me. I need to set the default date for a column in
> postgres. A value for today, today + x days, now (timestamp), now + x amount
> of
> days.
test=# select current_date;
date
2006-02-20
(1 row)
te
This issue always stumps me. I need to set the default date for a column in
postgres. A value for today, today + x days, now (timestamp), now + x amount of
days.
I never seem to be able to locate it in the documentation or online. Can anyone
post it here once and for all for posterity?
I will b
Frank Church wrote:
This issue always stumps me. I need to set the default date for a column in
postgres. A value for today, today + x days, now (timestamp), now + x amount of
days.
CURRENT_DATE, CURRENT_DATE + x, now(), now() + 'x days'::interval are a
few options.
--
Alban Hertroys
[EMAIL
This issue always stumps me. I need to set the default date for a column in
postgres. A value for today, today + x days, now (timestamp), now + x amount of
days.
I never seem to be able to locate it in the documentation or online. Can anyone
post it here once and for all for posterity?
I will be