From: "postgresql" <[EMAIL PROTECTED]>
> This is a rather generic question about "date" and "time". I seem to
> be beating my head on the wall. I was trying to use a set up a table
> with a 'date' and 'time' field. I wanted to keep the two separate.
>
> Can someone explain if there is a differen
This is a rather generic question about "date" and "time". I seem to
be beating my head on the wall. I was trying to use a set up a table
with a 'date' and 'time' field. I wanted to keep the two separate.
Can someone explain if there is a difference between a time field
and a timestamp. I do
On Thu, Jan 25, 2001 at 08:49:27AM +1300, Glen and Rosanne Eustace wrote:
> 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'
This almost sounds like it takes the year 2000,
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 Eusta