Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f0R0unq69238 for ; Fri, 26 Jan 2001 19:56:49 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from vmx.mediaparks.lv (vmx.mediaparks.lv [62.85.15.11]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0QIi2q33945 for ; Fri, 26 Jan 2001 13:44:03 -0500 (EST) (envelope-from emils@grafton.lv) Received: (from mail@localhost) by vmx.mediaparks.lv (8.9.3/8.9.3) id UAA99157 for pgsql-sql@postgresql.org; Fri, 26 Jan 2001 20:44:01 +0200 (EET) (envelope-from emils@grafton.lv) X-Authentication-Warning: vmx.mediaparks.lv: mail set sender to emils@grafton.lv using -f Received: from 159.148.192.252 by 62.85.15.11 id Ed75QuCa ; 26 Jan 2001 20:43:55 EET Received: from mortyr (mortyr.grafton.lv [159.148.192.196]) by home.grafton.lv (8.9.3/8.8.7) with ESMTP id UAA16589 for ; Fri, 26 Jan 2001 20:43:27 -0200 From: "Emils Klotins" Organization: Grafton Entertainment To: "'pgsql-sql@postgreSQL.org'" Date: Fri, 26 Jan 2001 20:45:08 +0200 MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-transfer-encoding: 7BIT Subject: Re: DATE Message-ID: <3A71E1D4.1119.EC6AF3E@localhost> In-reply-to: <07EB26C562C6D411ACE900C04FA33F8F5438@UKMAIL> X-mailer: Pegasus Mail for Win32 (v3.12c) X-Archive-Number: 200101/402 X-Sequence-Number: 1077 > 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