This is the query i have used to check condition. So far i didn't get the solution. When am execute got error as Missing keyword. How to do this.
select * from customer where status='A' and (case when trim(member_since) is not null then member_since > TO_DATE ( '20160112 235959' , 'YYYYMMDD HH24MISS')
else registration_date <=TO_DATE ( '20160112 235959' , 'YYYYMMDD HH24MISS') end)