Problem with Dates - Mailing list pgsql-sql

From Glen and Rosanne Eustace
Subject Problem with Dates
Date
Msg-id 00ff01c0863e$c4ef8620$0101a8c0@godzone.net.nz
Whole thread Raw
Responses Re: Problem with Dates  (Mike Castle <dalgoda@ix.netcom.com>)
List pgsql-sql
I am using 7.0.3,
I have a column tstamp defined to be 'date';

With a current value of '31-12-2000',
if I update tstamp=tstamp+'1 year'::timespan
I get '1-1-2002'

Is this what is supposed to occur.
If this isn't the right way to do this, how should it be done ?

Thanks
-- 
Glen and Rosanne Eustace,
GodZone Internet Services, a division of AGRE Enterprises Ltd.,
P.O. Box 8020, Palmerston North, New Zealand
Ph: +64 6 357 8168, Mobile: +64 21 424 015



pgsql-sql by date:

Previous
From: David Olbersen
Date:
Subject: Please don't kill me!
Next
From: Stephan Szabo
Date:
Subject: Re: Making a foreign key chain - good idea or bad idea?