6 AM TO 6 AM (FOR AN MONTH ) LIKE MONTH WISE (FINANCIAL YEAR)

AND jowl.creation_date
                                                                   BETWEEN   TRUNC
                                                                                (TO_DATE
                                                                                    (t_date
                                                                                    ),
                                                                                 'mm'
                                                                                )
                                                                           + (  6
                                                                              / 24
                                                                             )
                                                                       AND   TRUNC
                                                                                (TO_DATE
                                                                                    (t_date
                                                                                    ),
                                                                                 'dd'
                                                                                )
                                                                           + (  359.99
                                                                              / 1440
                                                                             )
                                                                           + 1