Need to retrieve last one hour records from database
627800Mar 11 2008 — edited Mar 12 2008Hi I am Srinivas V, I am new to this forum.
I want to retrieve calls done in last one hour.
ONLINE_BALANCE is table name
DATETIME is colomn name
and GROUPID is another colomn name
The query i had written is this
select count(*) as a from ONLINE_BALANCE where TO_CHAR(DATETIME,'MM/DD/YYYY HH:MI:SS') > 'SYSDATE-600/86400';
Suggest me with necessary modification in that
And i want to PUT this in Java Application ,
What should be the format and query
Waiting for the response ..