Skip to main content

This is documentation for Caché & Ensemble. See the InterSystems IRIS version of this content.

For information on migrating to InterSystems IRIS, see Why Migrate to InterSystems IRIS?


A MultiValue internal-to-external conversion function for dynamic arrays.




Argument Description
dynarray A MultiValue dynamic array, each element of which specifies a value in internal (storage) format.
code A character code, specified as a quoted string, that specifies the type of conversion to perform. Conversion is from internal format to external format.


The $MVOCONVS function is a MultiValue conversion function used to convert the element values in a MultiValue dynamic array from internal (storage) format to external (output) format. The type of conversion is specified by a character code string that is specific to the type of data to be converted.

$MVOCONVS is a Caché SQL extension and is intended for MultiValue data compatibility. It is functionally identical to the MultiValue OCONVS function, as described in the Caché MVBasic Reference. Refer to OCONVS for further information.

The following types of conversions are supported:

  • Character conversions: character-to-code, code-to-character.

  • Numeric conversions: decimal-to-hex, hex-to-decimal, masked decimal conversion, range extraction.

  • String conversions: case conversion, Soundex conversion, string length conversion, uniform string length adjustment, delimited substring extraction, pattern match extraction, string extraction by length.

  • Time and Date conversions: time internal-to-display format, date internal-to-display format, date display-to-internal format, date element extraction, date day-of-week, day-of-year, and quarter calculation.

The $MVOCONVS function converts dynamic array elements from internal format to external format. The $MVICONVS function converts dynamic array elements from external format to internal format. You can use the $MVOCONV function to convert a string from internal format to external format.

See Also