Re: [HACKERS] TO_DATE behavior!

2008-02-21 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Gevik Babakhani wrote: >> I would like to have your opinion about the following behavior of TO_DATE. >> Is this correct or a hidden feature? > There are quite a few complaints in the archive about to_date's incorrect or > questionable behavior. I'm

Re: [HACKERS] TO_DATE behavior!

2008-02-21 Thread Gevik Babakhani
> There are quite a few complaints in the archive about > to_date's incorrect or questionable behavior. I'm sure this > is one of them. This code needs a general, systematic review. I am working on a todo item. I'll report and fix anything I encounter there. Regards, Gevik

Re: [HACKERS] TO_DATE behavior!

2008-02-21 Thread Peter Eisentraut
Gevik Babakhani wrote: > I would like to have your opinion about the following behavior of TO_DATE. > Is this correct or a hidden feature? There are quite a few complaints in the archive about to_date's incorrect or questionable behavior. I'm sure this is one of them. This code needs a general

[HACKERS] TO_DATE behavior!

2008-02-21 Thread Gevik Babakhani
I would like to have your opinion about the following behavior of TO_DATE. Is this correct or a hidden feature? case: 'mon 21-feb-2008' is obviously a bad date. It should be 'thu 21-feb-2008' test: testdb=# select to_date('mon 21-feb-2008','dy dd-mon-'); to_date 2008-02-21 (1