select *
from TABLE_A WHERE TO_CHAR(BUSINESS_DATE,'DD-MON-yyyy') = (select DISTINCT (to_CHAR(BUSINESS_DATE, 'DD-MON-yyyy'))
from TABLE_B WHERE ROWNUM < 2);
TO_CHAR(BUSINESS_DATE,'DD-MON-yyyy')
THE RESULT LIKE THIS
07-APR-2011
select *
from TABLE_A WHERE TO_CHAR(BUSINESS_DATE,'DD-MON-yyyy') = (select DISTINCT (to_CHAR(BUSINESS_DATE, 'DD-MON-yyyy'))
from TABLE_B WHERE ROWNUM < 2);
TO_CHAR(BUSINESS_DATE,'DD-MON-yyyy')
THE RESULT LIKE THIS
07-APR-2011