SQL> select to_char(to_date('20021231','yyyymmdd'),'dd/mm/yyyy') from dual; TO_CHAR(TO ---------- 31/12/2002
Forum Rules