Hi Friends,

I am trying to work out what the 'RR' Parameter in the to_data function represents. Can anyone please explain.

Also..

I entered the following in sqlplus :

select
to_date(SYSDATE,'DD-MON-YYYY RR')
from dual

and got the following error

ORA-01840: input value not long enough for date format
anybody know why?

What would be the correct syntax to display 'RR' as part of a date ?
What is it ?

Many Thanks

Suresh