Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Conversion Functions

 

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>