XML DateTime Data Type

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

XML DateTime Data Type

fbibire
When retrieving a date column from an Oracle database using Orbeon SQL processor, this date is returned in this format: 'yyyy/mm/dd'.  I would have expected to be either date (2002-09-24) or datetime(2002-05-30T09:00:00). For example I have:
<xsl:template name="abc">
        <xsl:param name="id-in"/>
        SELECT  current_date
        FROM    My_Table
        WHERE ....
</xsl:template>
Does anybody know how to return this in a standard XML datetime?
Thanks.