Hi
I'm using postgres to track events. I need to insert date and time
of these events, and i'm having trouble when the seconds are 00.
Here is an example with psql
miguel=> create table tmp (d datetime);
CREATE
miguel=> insert into tmp values ('1999-11-18 13:00:00');
INSERT 20585 1
miguel=> select * from tmp;
d
-------------------------------
Thu Nov 18 13:00:60.00 1999 ART
(1 row)
13:00:00 has changed to 13:00:00. Now if I try to insert this value I
get: ERROR: Bad datetime external representation 'Thu Nov 18
13:00:60.00 1999 ART'
I'm using Postgresql 6.5.1, as it comes with Linux Mandrake 6.1.
Thanks in advance
Miguel Montes