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

Where condition not working using sysdate


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,'') = to_date(sysdate(),'')

There are 4 records with stat_date with todays date and the stat_flag is 'Updated Record'

Thanks for teh helpful info.