select only hours from date type SQL ORACLE code example

Example: oracle sql day of month from date

select extract(day from systimestamp) from dual;