Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-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

pgsql-hackers by date

Next:From: Thomas LockhartDate: 2000-08-17 04:41:18
Subject: Re: datetime_in()
Previous:From: Marten FeldtmannDate: 2000-08-16 21:01:24
Subject: Index-Function for Strings ....

pgsql-bugs by date

Next:From: Stephan SzaboDate: 2000-08-17 06:19:20
Subject: Re: [BUGS] help me
Previous:From: Philip PolesDate: 2000-08-16 20:30:18
Subject: Creation of 10000's of empty table segments and more...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group