If you need to transform a DATE or NUMBER into a STRING, the function that ORACLE provides is TO_CHAR. Much like TO_DATE.
Here are examples of how to apply it:
TO_CHAR (1210.73, ‘9999.9’)
Result: ‘1210.7’TO_CHAR (sysdate, ‘yyyy / mm / dd’)
Result: ‘2003/07/09’
Pretty simple, right?
Inquiries, please contact us.
Eduardo Santana
bufallos@bufallos.com.br