Bug in to_timestamp()

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:
---------------------------------------------------------------------
?

Responses

Browse pgsql-bugs by date

  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...

Browse pgsql-hackers by date

  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 ....