date function problem - Mailing list pgsql-sql

From mohan@physics.gmu.edu
Subject date function problem
Date
Msg-id 61599.138.88.163.115.1075823505.squirrel@physics.gmu.edu
Whole thread Raw
Responses Re: date function problem
Re: date function problem
List 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




pgsql-sql by date:

Previous
From: Jan Wieck
Date:
Subject: Re: Sometimes referential integrity seems not to work
Next
From: Larry Rosenman
Date:
Subject: Re: date function problem