Sunday, November 7, 2010

Parsing DATE to VARCHAR

SELECT TO_CHAR(TO_DATE('01-JAN-2008', 'DD-MM-YYYY'), 'YY')
FROM dual;

in here I would just like to extract the last 2 digits of the year and retrieve it as VARCHAR

No comments:

Post a Comment