15.27 STRINGIFY Function Signature 3

This function converts a date to an escaped JSON value.

Syntax

APEX_JSON.STRINGIFY (
    p_value  IN DATE,
    p_format IN VARCHAR2 DEFAULT c_date_iso8601 )
RETURN VARCHAR2;

Parameters

Table 15-31 STRINGIFY Function Parameters

Parameter	Description
`p_value`	The date value to be converted.

Returns

Table 15-32 STRINGIFY Function Returns

Return	Description
`VARCHAR2`	The converted and escaped JSON value.

Example

This example is a query that returns a JSON varchar2 value that is suitable to be converted to dates.

select apex_json.stringify(sysdate) from dual