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.
Tiene que estar conectado y contar con un contrato de mantenimiento vigente para ver los artículos de conocimiento premium.
© ALL RIGHTS RESERVED. Feedback Términos de uso Privacidad Cookie Preference Center