From: | "Gqms2 Galway" <gqms2(at)nortelnetworks(dot)com> |
---|---|
To: | "'pgsql-bugs(at)postgresql(dot)org'" <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Bug in to_timestamp() |
Date: | 2000-08-16 21:41:18 |
Message-ID: | D1D98F1AD709D311827F0000F805F05101ACF6DB@zgalda02.europe.nortel.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs pgsql-hackers |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Neil Bloomer
Your email address : neilbloomer(at)coneyislandsystems(dot)com
System Configuration
---------------------
Architecture (example: Intel Pentium) : Pentium II 266
Operating System (example: Linux 2.0.26 ELF) : Red Hat Linux 6.1
PostgreSQL version (example: PostgreSQL-7.0): PostgreSQL 7.0.2 on
i686-pc-linux-gnu, (Red Hat RPM)
Compiler used (example: gcc 2.8.0) : compiled by gcc
egcs-2.91.66
Please enter a FULL description of your problem:
------------------------------------------------
The to_timestamp function is not working as per the documentation. See the
examples below.
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
The following results were returned when the queries were executed through
ipgsql, and similar results are returned through psql.
select to_timestamp('20000816000001', 'YYYYMMDDHH24MISS') returns
'30/12/1899' (wrong)
select to_timestamp('2000 0816000001', 'YYYY MMDDHH24MISS') returns
'16/08/2000 00:00:01' (ok)
select to_timestamp('000816000001', 'YYMMDDHH24MISS') returns '16/08/0001'
(wrong)
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
?
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2000-08-17 06:19:20 | Re: [BUGS] help me |
Previous Message | Philip Poles | 2000-08-16 20:30:18 | Creation of 10000's of empty table segments and more... |
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 2000-08-17 04:41:18 | Re: datetime_in() |
Previous Message | Marten Feldtmann | 2000-08-16 21:01:24 | Index-Function for Strings .... |