CFStoredProc - Lucee converts DateTime values to string differently than ACF

When using a stored procedure to return a value from a column of datatype ‘datetime’, Lucee wraps the value in a “ts” format, whereas ACF returns the value without additional formatting.

Example Results:

• ACF: 2025-04-15 10:44:54

• Lucee: {ts '2025-04-15 10:44:54'}

Inserting new values using a CFSQLType of “CF_SQL_TIMESTAMP” works as expected. In the attached figures, the entries were inserted into the test table using the same stored procedure. The results in Figure 1 show the entries as displayed by SSMS.

When selecting the entries via the same stored procedure, the results from ACF and Lucee differ. Figure 2 shows a <cfdump> of the query results under ACF, whereas Figure 3 shows the same results under Lucee.

All of the test DDL, stored procedures, and CFM used to produce these results as well as all figures have been included as an attachment.