Examples:
-- select last one minute data from table
select * from TRANSACTION t
where T.CREATED>=sysdate - 1/1440
order by created;
or
select * from TRANSACTION t
where T.CREATED>=sysdate - 1/24/60
order by created;
or
select * from TRANSACTION t
where T.CREATED>=sysdate - INTERVAL '1' MINUTE
order by created;
-- select last five minute data from table
select * from TRANSACTION t
where T.CREATED>=sysdate - 5/1440
order by created;
or
select * from TRANSACTION t
where T.CREATED>=sysdate - 5/24/60
order by created;
or
select * from TRANSACTION t
where T.CREATED>=sysdate - INTERVAL '5' MINUTE
order by created;
-- select last one second data from table
select * from TRANSACTION t
where T.CREATED>=sysdate - 1/86400
order by created;
or
select * from TRANSACTION t
where T.CREATED>=sysdate - 1/24/60/6
order by created;
or
select * from TRANSACTION t
where T.CREATED>=sysdate - INTERVAL '1' SECOND
order by created;
-- Select last one hour data from table
select * from TRANSACTION t
where T.CREATED>=sysdate - 1/24
order by created;
or
select * from TRANSACTION t
where T.CREATED>=sysdate - INTERVAL '1' HOUR
order by created;
-- Select last 12 hour data from table or select last 1/2 day data from table
select * from TRANSACTION t
where T.CREATED>=sysdate - 12/24
order by created;
or
select * from TRANSACTION t
where T.CREATED>=sysdate - 1/2
order by created;
or
select * from TRANSACTION t
where T.CREATED>=sysdate - INTERVAL '12' HOUR
order by created;
-- select last 1 day data from table
select * from TRANSACTION t
where T.CREATED>=sysdate - 1
order by created;
or
select * from TRANSACTION t
where T.CREATED>=sysdate - INTERVAL '1' DAY
order by created;