Skip to Main Content

Japanese

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how do I format a date MM/DD/YYYY HH:MM:SS in default_where statement?

2838586Mar 8 2019

I'm trying to format a date in a default_where statement and I cannot get it to parse correctly.

Set_Block_Property('EPB_RECS_MODIFIED_TODAY',DEFAULT_WHERE,

       'corp_no = ''' || :eftpart.corp_no

       || '''' ||' and appl_no = ''' || :eftpart.appl_no

       || '''' ||' and class_cd = ''' || :eftpart.class_cd

       || '''' ||' and part_key = ''' || :eftpart.part_key

       || '''' ||' and to_char(date_last_maint, ''MM/DD/YYYY HH:MI:SS'') = to_char('||:global.date_last_maint ||',''MM/DD/YYYY HH:MI:SS'')';

Comments
Post Details