The descriptions for the following Code Snippets are incorrect:
TO_CHAR(sysdate) reads:
Given a current date of 2/25/97, returns '27-FEB-97'
It should read:
Given a current date of 2/25/97, returns '25-FEB-97'
TO_CHAR(sysdate, 'MM/DD/YY') reads:
Given a current date of 2/25/97, returns '02/27/97'
It should read:
Given a current date of 2/25/97, returns '02/25/97'
TO_CHAR(sysdate, 'DDD') reads:
Given a current date of 2/25/97, returns the 3 digit day of the year 058
It should read:
Given a current date of 2/25/97, returns the 3 digit day of the year 056
TO_CHAR(sysdate, 'J') reads:
Given a current date of 2/25/97, returns the Julian date '2450507'
It should read:
Given a current date of 2/25/97, returns the Julian date '2450505'
It looks like the date of 2/27/97 was really used in the example.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center