Showing posts with label DFF. Show all posts
Showing posts with label DFF. Show all posts

Sunday, July 28, 2019

Filter varchar2 columns for date values only IMP for DFFs

Filter varchar2 columns for date values only IMP for DFFs

Its helpful when date values only have to filter from DFF attributes.
As the attribute can have any data type value.
So if we use below where condition the future errors can be handled.

where
regexp_like (a.segment3, '[0-9]{4}/(0[0-9]|1[0-2])/([0-2][0-9]|3[0-1])')