Postgres Pro
Downloads
Home   >   mailing lists

Re: Help with simple function - Mailing list pgsql-admin

From Chris Hoover
Subject Re: Help with simple function
Date
Msg-id 1d219a6f0512280733k74c7ecf6kdff6408ba6c6bfa5@mail.gmail.com
Whole thread Raw
In response to Re: Help with simple function  ("Jason Minion" <jason.minion@sigler.com>)
List pgsql-admin
Tree view
On 12/28/05, Jason Minion <jason.minion@sigler.com> wrote:
And last but not least, you can do simple day addition and subtraction
with dates using integers. For example:

> select '2005-12-26'::date + 8;

returns '2006-01-03'. However, I'm not sure if that will work with
7.3.x. Good luck with your 8.x install!

Jason

That works like a charm.  Thanks a bunch for the help.

Chris


pgsql-admin by date:

Previous
From: Bradley Kieser
Date:
Subject: Re: migrating oracle table to PostgresQL
Next
From: Tom Lane
Date:
Subject: Re: restored database locale problem