Oracle RR Date Format
TELL ME ABOUT RR DATE FORMAT IN ORACLE9I(SQL)
Software/Hardware used:
Software/Hardware used:
ASKED:
May 27, 2009 8:43 AM
UPDATED:
August 9, 2011 6:19 AM
Answer Wiki:
"The RR datetime format element is similar to the YY datetime format element, but it provides additional flexibility for storing date values in other centuries. The RR datetime format element lets you store 20th century dates in the 21st century by specifying only the last two digits of the year.
If you use the TO_DATE function with the YY datetime format element, then the year returned always has the same first 2 digits as the current year. If you use the RR datetime format element instead, then the century of the return value varies according to the specified two-digit year and the last two digits of the current year."
<a href="http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/sql_elements004.htm#SQLRF00215">Read more...</a>
To see all answers submitted to the Answer Wiki: View Answer History.
To-char(hire_date -1, ‘d’);
hi
is this with the user requirement that you can ask to print a date in next century or if it calculates the date automatically on its own.???
please explain
I see that this post is a little bit old but anyway, I am using for oracle date format this website http://www.sql-performance-tuning.com/oracle-date-format/
You will find on this website complete list of Oracle format elements and som examples.