| 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: | Whole Thread | Raw Message | 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 .... |