Re: Problem with date calculations - Mailing list pgsql-general

From Stephan Szabo
Subject Re: Problem with date calculations
Date
Msg-id 20040110145131.G19122@megazone.bigpanda.com
Whole thread Raw
In response to Problem with date calculations  ("Cornelia Boenigk" <poppcorn@cornelia-boenigk.de>)
List pgsql-general
On Sat, 10 Jan 2004, Cornelia Boenigk wrote:

> I have a table with two fields, d1 timestamp and dur smallint.
> d1 is the starting date and dur is the duration. From this two fields
> I want to generate future dates for the whole table.

I'd suggest using something like:
 d1 + dur * interval '1 month'
rather than attempting to do it via text.

pgsql-general by date:

Previous
From: "Cornelia Boenigk"
Date:
Subject: Problem with date calculations
Next
From: "Cornelia Boenigk"
Date:
Subject: Re: Problem with date calculations