Conversion Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Conversion Functions
  4. To_char(to_date(01012006,ddmmyyyy),is on Day) as new_year_2006
SQL>
SQL> select sysdate                       as today
  2  ,      to_char(to_date('01/01/2006','dd/mm/yyyy'),'"is on "Day') as new_year_2006
  3  from dual;
TODAY     NEW_YEAR_2006
--------- ---------------
24-JUL-08 is on Sunday
SQL>