| 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: | 20050930080742.A5927F0E89@svr2.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-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
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Till Toenges | 2005-09-30 13:38:47 | BUG #1928: Postgresql is terminated by signal 10 (bus error) when using prepared statements |
| Previous Message | Kevin Waldron | 2005-09-30 04:44:11 | BUG #1926: /etc/init.d/postgresql - script version 7.4.5 fails on startup |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-09-30 21:23:11 | fuzzystrmatch URL, spelling corrections |
| Previous Message | Bruce Momjian | 2005-09-29 14:26:43 | Re: [PATCHES] Proposed patch for sequence-renaming problems |