Omit the time value
Hello ,
I need to omit the time value output from the below query :
select * from tbraccd inner join TBBDETC on TBRACCD_DETAIL_CODE=TBBDETC_DETAIL_CODE
where tbraccd.TBRACCD_EFFECTIVE_DATE > to_date ('2021/12/31', 'yyyy/mm/dd')
AND tbraccd.TBRACCD_EFFECTIVE_DATE <= to_date('2022/07/1', 'yyyy/mm/dd');