date function problem

From: mohan(at)physics(dot)gmu(dot)edu
To: <pgsql-sql(at)postgresql(dot)org>
Subject: date function problem
Date: 2004-02-03 15:51:45
Message-ID: 61599.138.88.163.115.1075823505.squirrel@physics.gmu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi All
I have an expiration_date column in my table with data type as timestamp.
I need to set that as one year after the current time. how do i do that. I
am getting a casting problem whenever i try something.

something like now()+ 1 year. Please let me know

--mohan

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Larry Rosenman 2004-02-03 16:01:22 Re: date function problem
Previous Message Christoph Haller 2004-02-03 15:08:05 Re: locking problem