SQL> select to_number(to_char(current_timestamp,'hh24'),'99') as hr,
to_number(to_char(current_timestamp,'mi'),'99') as min,
to_number(to_char(current_timestamp,'ss'),'99') as sec,
to_number(to_char(current_timestamp,'dd'),'99') as day,
to_number(to_char(current_timestamp,'mm'),'99') as mth,
to_number(to_char(current_timestamp,'yyyy'),'9999') as yr;
hr | min | sec | day | mth | yr
----+-----+-----+-----+-----+------
23 | 58 | 31 | 23 | 12 | 2012
(1 row)
scott@cloud-00:5432:scottdb]
SQL>
