ORACLE CONVERSION - TO_CHAR

1. CREATE INDEX
2. DECODE
3. TO_CHAR
4. TO_DATE
5. SELECT
6. GRANT
7. INSERT
8. TUNNING
9. UPDATE
10. CREATE USER

Funcion TO_CHAR

Convierte una fecha a una cadena o un número con el formato especificado.

TO_CHAR(date1 [,fmt]);

TO_CHAR(number1 [,fmt])

SELECT TO_CHAR(sysdate) FROM DUAL;

15-JUN-01

SELECT TO_CHAR(sysdate, 'dd/mm/yyyy') FROM DUAL;

15/06/2001

SELECT TO_CHAR(sysdate,'Mon') FROM DUAL;

Jun

SELECT TO_CHAR(sysdate, 'Month') FROM DUAL;

Junio

SELECT TO_CHAR(sysdate, 'DDD') FROM DUAL;

058

SELECT TO_CHAR(123.456, '09999') FROM DUAL;

00123

SELECT TO_CHAR(123.456, '09999.9') FROM DUAL;

00123.5

SELECT TO_CHAR(123456, 'FM999,999,999') FROM DUAL;

123,456