14- HOW TO CONVERT / TRANSFORM DATA
CONVERSION:
→To-char Transforms a DATE or NUMBER into a character string,
→To_date Transforms a Number, char or varchar2 into a DATE
→To_Number Transforms a char, varchar2 into a
NUMBER,
One may enter the date in different ways such as
01-dec-2010, 01-12-2010, 2010-12-01, 12-01-2010
SQL EXPRESSION
RESULT
TO-DATE('01-DEC-2010')
'01-DEC-10
TO-DATE('01-12-
2010','DD-MM-YYYY')
We have seen some of the retrieval on selective data types like char, varchar2, number and data, Of course, the seen examples are very illustrative and not