Re: DATE

From: "Emils Klotins" <emils(at)home(dot)grafton(dot)lv>
To: "'pgsql-sql(at)postgreSQL(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: Re: DATE
Date: 2001-01-26 18:45:08
Message-ID: 3A71E1D4.1119.EC6AF3E@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> PLEASE ADVISE HOW I SHOULD ALTER THE COMMAND:
>
> <$NOW;DDMMMM;YYYY>
>
> TO GIVE ME A DATE THAT IS X DAYS FORWARD
>
> ie: I WISH TO REPRESENT A DATE IN FORM WHICH IS A 7 DAYS FORWARD
> OF THE DATE NOW.
( now() + '7 days'::interval )::date (or ::datetime, whichever you
need)

Emils

In response to

  • DATE at 2001-01-22 17:29:49 from john whale

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-01-26 19:04:00 Re: Request for change in PL/PGSQL function handler
Previous Message Emils Klotins 2001-01-26 18:42:44 Re: #DELETED error when using Access 2000 as frontend