Pg subtracts one minute from time - Mailing list pgsql-novice

From Barry Stewart
Subject Pg subtracts one minute from time
Date
Msg-id 20010112081924.A5038@genesis.kingdom.net
Whole thread Raw
Responses Re: Pg subtracts one minute from time  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-novice
Help!

Postgresql subtracts one minute from any times I enter into a database:

mydb=# create table test (timeval time);
CREATE
mydb=# insert into test values ('02:00');
INSERT 22313 1
mydb=# insert into test values ('03:00:00');
INSERT 22314 1
mydb=# insert into test values ('08:30');
INSERT 22315 1
mydb=# select * from test;
 timeval
----------
 01:59:00
 02:59:00
 08:29:00
(3 rows)

mydb=#


What am I doing wrong?

Thanks,

Barry

pgsql-novice by date:

Previous
From: Albert Reiner
Date:
Subject: Re: RecordSets, getString and charSets
Next
From: mat@reynerie.yi.org
Date:
Subject: problem with pg_dump