0

Date between

Hi,

 

Can you please let me know how to write below condition in materialized view in where condition?

 To_date(WSH.WSH_NEW_DELIVERIES.ATTRIBUTE1, 'DD-MON-YYYY') BETWEEN TRUNC(sysdate -2) AND trunc(sysdate +2)  )

Regards,

KHK.

2replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
Like Follow
  • 2 wk agoLast active
  • 2Replies
  • 14Views
  • 3 Following

Product Announcement

Incorta 4.9 is now Generally Available (GA)!!!