Statement to retrieve time in Oracle

select to_char(sysdate, 'Dy DD-Mon-YYYY HH24:MI:SS')

count time timestamp
select * from ticket where s= rowstamp countstamp