Bug in to_timestamp()
От | Gqms2 Galway |
---|---|
Тема | Bug in to_timestamp() |
Дата | |
Msg-id | D1D98F1AD709D311827F0000F805F05101ACF6DB@zgalda02.europe.nortel.com обсуждение исходный текст |
Ответы |
Re: Bug in to_timestamp()
|
Список | pgsql-bugs |
============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : Neil Bloomer Your email address : neilbloomer@coneyislandsystems.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: --------------------------------------------------------------------- ?
В списке pgsql-bugs по дате отправления: