TO_CHAR Formats

SELECT to_char(SYSDATE, 'dd/mm/yyyy HH:MI') FROM DUAL;
output character: 08/07/2008 04:54

select to_char(CURRENT_DATE, 'dd/mm/yyyy HH:MI') from dual;
output character : 08/07/2008 04:54

SELECT to_char(SYSDATE, 'day/mon/yyyy HH24:MI:SS') FROM DUAL;
output character : thursday/jul/2008 15:34:30