ORACLE regularization solves initial data format inconsistencies
- 2020-06-03 08:39:50
- OfStack
Such as: the = = 2000-1-1
>
The 2000-01-01, 2000-01-01 = =
>
The 2000-01-01, 2000-01-01 = =
>
2000-01-01
I used to write a script like function/procedure, lots of IF ELSE...
This time I accidentally found that oracle10g already supports regularization, so the above problem was solved.
I used to write a script like function/procedure, lots of IF ELSE...
This time I accidentally found that oracle10g already supports regularization, so the above problem was solved.
UPDATE LZ__EQ_RHGL LZRH SET LS__SP_GHTIME = SUBSTR(LZ__SP_GHTIME, 1, 5) || '0' || SUBSTR(LZ__SP_GHTIME, 6, 2) || '0' || SUBSTR(8, 1) WHERE RETEXT_LINE(LZ__SP_GHTIME, '^\d{4}-\d{1}-\d{1}$')