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.
WORKAROUND
none
STATUS
Issue fixed in version 10. The latest version of Toad for Oracle can be downloaded here.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center