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