Deyan Chepishev wrote:
The following bug has been logged online:

Bug reference: 1927
Logged by: Deyan Chepishev
Email address: updates@blue-edge.bg
PostgreSQL version: 7.4.8, 8.0.3
Operating system: Linux
Description: incorrect timestamp returned
Details:

Postgre:
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
It's the leap second.


Regards
Gaetano Mendola

Search Discussions

Discussion Posts

Previous

Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 2 of 9 | next ›
Discussion Overview
grouppgsql-bugs @
categoriespostgresql
postedSep 30, '05 at 8:12a
activeOct 4, '05 at 4:43p
posts9
users7
websitepostgresql.org
irc#postgresql

People

Translate

site design / logo © 2022 Grokbase