From: Emils Klotins <emils@home.grafton.lv>
To: 'pgsql-sql@postgreSQL.org' <pgsql-sql@postgresql.org>
Subject: Re: DATE
Date: Fri, 26 Jan 2001 20:45:08 +0200
Message-ID: <3A71E1D4.1119.EC6AF3E@localhost> (raw)
In-Reply-To: <07EB26C562C6D411ACE900C04FA33F8F5438@UKMAIL>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: emils@home.grafton.lv
Subject: Re: DATE
In-Reply-To: <3A71E1D4.1119.EC6AF3E@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox