Tom Lane wrote:
> Bruce Momjian <br...@momjian.us> writes:
> > Tom Lane wrote:
> >> Anybody know what Oracle's to_timestamp does?
> 
> > The old thread reported Oracle returned an error;
> >     http://archives.postgresql.org/pgsql-bugs/2009-06/msg00100.php
> 
> Well, nothing's likely to get done about it for 9.0.  Maybe we should
> add a TODO item for further tightening of the function's error checking.

There doesn't seem to be any error checking:

        test=> select to_timestamp('20090140','YYYYMMDD');
              to_timestamp
        ------------------------
         2009-02-09 00:00:00-05
        (1 row)

The odd thing is we seems to do something reasonable for some definition
of reasonable so maybe we just leave it unchanged.

-- 
  Bruce Momjian  <br...@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com
  PG East:  http://www.enterprisedb.com/community/nav-pg-east-2010.do
  + If your life is a hard drive, Christ can be your backup. +

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to