USFormat.CharRemoveIOFormat

Removes a string format, using the string IO format pattern for the format to be removed.

Returns the result of removing the format.

Syntax

SELECT USFormat.CharRemoveIOFormat(

         string

,        string-io-format-pattern

)

Both string and string-io-format-pattern are required. String-io-format-pattern must be one of the USoft IO format patterns used for string values.

Example

SELECT USFormat.CharRemoveIOFormat(

         '12-MAR-2019'

,        '99-XXX-9999'

)

The return value of this statement is:

12MAR2002