-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|