USFormat.CharRemoveIOFormat

Previous Next

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

Returns the result of the operation as a string.

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 format patterns for string values.

Example

SELECT USFormat.CharRemoveIOFormat(
         '12-MAR-2019'
,        '99-XXX-9999'
)

The return value of this statement is:

12MAR2019