Pg subtracts one minute from time

From: Barry Stewart <bstewart(at)smyrnacable(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Pg subtracts one minute from time
Date: 2001-01-12 13:19:24
Message-ID: 20010112081924.A5038@genesis.kingdom.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Neil Ernstzen 2001-01-12 14:42:19 Creating tables from VB
Previous Message Albert Reiner 2001-01-12 12:13:57 Re: RecordSets, getString and charSets