Use of sysdate in oracle

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;