Comparing dates in the xsl file (in the SQL statement)

Use the Oracle to_date function. If you are using an ISO date (if you called DateIso() from ccs/common.js), you must use the date format 'YYYY-MM-DD"T"HH24:MI:SS'

AND (CREATETIME = to_date('<xsl:value-of select="@CREATETIME"/>','YYYY-MM-DD"T"HH24:MI:SS'))