how do I write a query in finacle where the query has to include date range of date and (date -1)
If I understand your question, then any of the below should work for you:
select routing_ref_num from tbaadm.smh where to_char(execution_date,’dd/mm/yyyy’) =’24/02/2020′ or to_char(execution_date,’dd/mm/yyyy’) =’23/02/2020′
select routing_ref_num from tbaadm.smh where to_char(execution_date,’dd/mm/yyyy’) between ’23/02/2020′ and ’24/02/2020′
Finacle is a registered trademark of Infosys Ltd.
Finaclestack is an independent resources site on Finacle solutions and is not in any way related to/owned by/managed by/under the control of Infosys.
Infosys is not responsible for the contents of this site or any link contained in this site or a linked site, or any changes or updates on this site.
Finaclestack provides these resources to you only as a convenience, and the inclusion of any object shall not be construed to imply endorsement by Infosys in any manner. We trustfully rely on the long years of experience of our community members.