Skip site navigation (1) Skip section navigation (2)

BUG #1927: incorrect timestamp returned

From: "Deyan Chepishev" <updates(at)blue-edge(dot)bg>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1927: incorrect timestamp returned
Date: 2005-09-30 08:07:42
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugspgsql-patches
The following bug has been logged online:

Bug reference:      1927
Logged by:          Deyan Chepishev
Email address:      updates(at)blue-edge(dot)bg
PostgreSQL version: 7.4.8, 8.0.3
Operating system:   Linux
Description:        incorrect timestamp returned

1. PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.3
20050227 (Red Hat 3.4.3-22.1)
2. PostgreSQL 7.4.8 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.4

When I run the following query:

select timestamp '2005-09-23 23:59:59.9999999'

I get the following result (note the value of the seconds):

2005-09-23 23:59:60.00


pgsql-bugs by date

Next:From: Till ToengesDate: 2005-09-30 13:38:47
Subject: BUG #1928: Postgresql is terminated by signal 10 (bus error) when using prepared statements
Previous:From: Kevin WaldronDate: 2005-09-30 04:44:11
Subject: BUG #1926: /etc/init.d/postgresql - script version 7.4.5 fails on startup

pgsql-patches by date

Next:From: Michael FuhrDate: 2005-09-30 21:23:11
Subject: fuzzystrmatch URL, spelling corrections
Previous:From: Bruce MomjianDate: 2005-09-29 14:26:43
Subject: Re: [PATCHES] Proposed patch for sequence-renaming problems

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group