ToChar

SQL

SELECT TO_CHAR(LOCALTIMESTAMP(0)) AS tocharnow,
       TO_CHAR(LOCALTIMESTAMP(0), 'yyyy-MM-dd') AS tocharnowFormat,
       TO_CHAR(2.24567, '0.99') AS tochardouble
  FROM Dual Dual01
 WHERE 1=1

XML query API

<query alias="testToCharFunction" projectedClass="DUAL_META_CLASS">
    <projections>
        <projection alias="tocharnow">
            <toChar>
                <date type="now" xsi:nil="true"/>
            </toChar>
        </projection>
        <projection alias="tocharnowFormat">
            <toChar>
                 <date type="now" xsi:nil="true"/>
                 <string bound="false">yyyy-MM-dd</string>
            </toChar>
        </projection>
        <projection alias="tochardouble">
            <toChar>
                <double>2.7689340174</double>
                <string bound="false">0.99</string>
            </toChar>
        </projection>
    </projections>
</query>