RE: DATE

From: Michael Davis <mdavis(at)sevainc(dot)com>
To: "'john whale'" <john(dot)whale(at)ukdirect(dot)org>, "'pgsql-sql(at)postgreSQL(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: RE: DATE
Date: 2001-01-24 05:22:36
Message-ID: 01C0858B.0037D020.mdavis@sevainc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Select now() + 7;

-----Original Message-----
From: john whale [SMTP:john(dot)whale(at)ukdirect(dot)org]
Sent: Monday, January 22, 2001 10:30 AM
To: 'pgsql-sql(at)postgreSQL(dot)org'
Subject: DATE

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.

REGARDS

JOHN WHALE

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Fork 2001-01-24 05:26:58 Re: unreferenced primary keys: garbage collection
Previous Message <No Name> 2001-01-24 05:02:40 SQL Query Results