| From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #1927: incorrect timestamp returned |
| Date: | 2005-10-01 11:48:38 |
| Message-ID: | dhlt2q$p91$1@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-patches |
Deyan Chepishev wrote:
> 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
It's the leap second.
Regards
Gaetano Mendola
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Warren Little | 2005-10-01 15:32:21 | BUG #1930: Cannot create foreign key constraint |
| Previous Message | Balaji NV | 2005-10-01 06:12:09 | Error While Connectint to Database |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2005-10-01 14:38:25 | Re: [HACKERS] Found small issue with OUT params |
| Previous Message | Dave Page | 2005-10-01 08:55:46 | Re: Found small issue with OUT params |