select sysdate
,extract(year from sysdate) as year
,extract(month from systimestamp) as month
,extract(timezone_hour from systimestamp) as tzh
from dual

/