regexp_replace in teradata for date value

Asked Mar 24 '23 at 02:30

Active Mar 24 '23 at 02:30

Viewed 16 times

I am using regexp_replace function in Teradata but encounters the below issues

I am looking to replace datevalue to YYYYMMDD.

Below is the query i have used

select RegExp_Replace('20230320',[0-9]{8},'YYYYMMDD')

error I get is " expected something between. and [ "

how do I achieve that in Teradata?

asked Mar 24 '23 at 02:30

PK39565

i think i have found issue as i didnt include single quote was throwing error – PK39565 Mar 24 '23 at 02:41
Yes, the pattern must be passed as string – dnoeth Mar 24 '23 at 08:22

0 Answers0