I am using the following condition within where, there are 4 records, but something is wrong, can you please advice:
rtrim_blanks(ltrim_blanks(TBL_DM_COMP.STAT_FLAG)) = 'Updated Record'
and to_date(TBL_DM_COMP.stat_date,'yyyy.mm.dd') = to_date(sysdate(),'yyyy.mm.dd')
There are 4 records with stat_date with todays date and the stat_flag is 'Updated Record'
Thanks for teh helpful info.