SQL & PL/SQL

Hi,

Oracle 10g r2.

I don't understand why this works :

select to_date('january 12 2011','MONTH DD YYYY HH24:MI:SS','nls_date_language=english') from dual

select to_date('january 12 2011','MONTH DDTH YYYY HH24:MI:SS','nls_date_language=english') from dual

and this don't :

select to_date('january 12th 2011','MONTH DDTH YYYY HH24:MI:SS','nls_date_language=english') from dual

=> ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Is it possible to do the conversion without having to modify session parameters ?

Thanks.

Yann.