Hi, im trying to do someting like this:
with t as (
SELECT '29-02-2032' dt,'^(\d{2})(\d{2})(\d{4})$|^(\d{2})-(\d{2})-(\d{4})$' er, '\3\2\1' rep FROM dual
)
select regexp_replace(t.dt,t.er, t.rep) from t;
According to the documentation should not be an impediment to use multiple patterns. However, this always returns NULL.
Any ideas?
Thank you.