SQL> select sysdate as today
2 , to_char(sysdate,'hh24:mi:ss') as time
3 , to_char(to_date('01/01/2006','dd/mm/yyyy')
4 ,'"is on "Day') as new_year_2006
5 from dual;
TODAY TIME NEW_YEAR_2006
---------- -------- ---------------
26-10-2009 10:03:46 is on Zondag
SQL>
SQL>