Oracle RR Date Format

5 pts.
Tags:
Oracle
Oracle 9i
SQL
TELL ME ABOUT RR DATE FORMAT IN ORACLE9I(SQL)

Answer Wiki

Thanks. We'll let you know when a new response is added.

“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>

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Ramandeepsingh
    To-char(hire_date -1, 'd');
    10 pointsBadges:
    report
  • ITOr4cle
    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
    10 pointsBadges:
    report
  • sulica
    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.
    235 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following