Skip to Content
0
Former Member
Oct 29, 2012 at 07:47 PM

Where condition not working using sysdate

22 Views

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.