select to_char(sys_date,'hh:mi:ss') from all_objects;
SYSDATE TO_CHAR(SYSDATE,'HH')
-------------------- ---------------------
2003-10-13 19:35:21 07
trunc(months_between( newer_date, older_date )/12) YEARS,
select to_char(add_months(last_day(sysdate) +1, -2), 'yyyymmdd'),last_day(sysdate)