Forum Stats

  • 3,750,549 Users
  • 2,250,192 Discussions
  • 7,867,004 Comments

Discussions

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

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'')';