New functions (FORMAT_DATE, FORMAT_NUM, and TO_INCODE) and an improved SUBSTR function

Magic

3.0.0

The functions FORMAT_DATE, FORMAT_NUM, and TO_INCODE have been added. In addition, the SUBSTR function has been improved.

FORMAT_DATE:

Converts the applicable character string to the specified date format.

FORMAT_NUM:

Converts the applicable character string to the specified numeric format.

TO_INCODE:

Converts the applicable character string to the specified input character encoding.

The external character and user code tables cannot be used.

SUBSTR:

The ADJUST parameter has been added. If the start or end position of variable-length characters (M-type, CSV string, or XML string) is in the middle of the string, you can move the position to the start or end of the string.