Re: date comparisons

["Chad Wagner" <chad.wagner@xxxxxxxxx>]

On 2/3/07, Bruce Momjian <bruce@xxxxxxxxxx> wrote:

Would someone please confirm that our behavior in the three queries
below matches Oracle's behavior?

Here is output from Oracle:

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> alter session set nls_timestamp_format = 'YYYY-MM-DD HH.MI.SSXFF AM';

Session altered.

SQL> select to_timestamp('January 2006', 'Month YYYY') from dual;

TO_TIMESTAMP('JANUARY2006','MONTHYYYY')
---------------------------------------------------------------------------
2006-01-01 12.00.00.000000000 AM

SQL> select to_timestamp('January   2006', 'Month YYYY') from dual;

TO_TIMESTAMP('JANUARY2006','MONTHYYYY')
---------------------------------------------------------------------------
2006-01-01 12.00.00.000000000 AM

SQL> select to_timestamp('January 2006', 'FMMonth YYYY') from dual;

TO_TIMESTAMP('JANUARY2006','FMMONTHYYYY')
---------------------------------------------------------------------------
2006-01-01 12.00.00.000000000 AM