Time needed in date and current hour only
641545Aug 14 2008 — edited Aug 14 2008I have a query it might be very simple.
I want to extract date and hour from sysdate.
Which and how functions should be used.
I want output as date and hour (like 14/08/2008 17:00).
I tried firing diff queries. like
Select to_date(sysdate, 'DD/MM/YYYY HH24') from dual;
But yet no correct output.
I need to save this value in a varible.
Please help.