============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Neil Bloomer
Your email address : [EMAIL PROTECTED]
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:
---------------------------------------------------------------------
?
