Math.random() ++
programming is an art, a form of expression only the logic side of our brain could appreciate
Pages
Home
Resources
Study List
Cheat Sheet
Notes
Nihongo
Zett
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment