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

No comments:

Post a Comment