Re: [SQL] datetime fields have '60' in seconds field - Mailing list pgsql-sql

> When a DATETIME field is modified and the seconds are set to zero, the field
> always shows 60 seconds instead:
> 
> testdb=> create table datetab (dt datetime);
> CREATE
> testdb=> insert into datetab (dt) values ('1999-12-31 12:05:00');
> INSERT 27361 1
> testdb=> select * from datetab;
> dt
> --------------------------
> 31/12/1999 12:05:60.00 MST
> (1 row)

Upgrade to Postgres 6.5.3 (redhat) from 6.5.1 (mandrake) fixed the problem.
Thanks.