How to compare dates on minute level in plsql?
You can use TRUNC (date) function which returns date with the time portion of the day truncated to the unit specified by the format model. 
Syntax:


TRUNC(date, fmt) or TRUNC(date).


Where fmt can be 'DAY', 'YEAR','HH','MI'.
For more format model please refer: ROUND and TRUNC Date Functions

Example:

SELECT 1 FROM sample_table WHERE TRUNC(sysdate,'MI')&lt;=TRUNC(sample_table_date_field,'MI');

Otherwise you can also use EXTRACT function to extract the elements from datetime.
Example:


SELECT 1 FROM dual WHERE extract(minute from systimestamp)=extract(minute from systimestamp);