how do I write a query in finacle where the query has to include date range of date and (date -1)

the query says”select routing_ref_num from tbaadm.smh where execution_date =(?var,’ dd-mm-yyyy’) or execution_date = (?var-1,’dd-mm-yyyy’)

How do i write the above code in finacle

Newbie Asked on February 22, 2020 in Customizations.
Add Comment
  • 2 Answer(s)

    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′

    Expert Answered on February 24, 2020.
    Add Comment

    or execution_date =( select (?var,’dd-mm-yyyy’) -1 from dual)

    Regular+ Answered on February 25, 2020.
    Add Comment

    Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.
  • Disclaimer:

    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.