Returns the current date and time in DateTime format, use the To_Char function to display this as a character string:
SQL> select to_char(sysdate,'HH24:MI:SS') "Time Now" from dual;
SQL> select to_char(sysdate,'YYYY MM DD') "Date" from dual;
Related
TO_CHAR - Convert to character string
TO_DATE - Convert to date value
Date format strings
Oracle SQL Functions