CFQuery - Lucee converts DateTime values to string differently than ACF

Description

Lucee converts query datetime values to strings differently than in ACF.

We have a big legacy app which uses datetime from one query in another query (unfortunately without cfqueryparam). The difference in format causes a SQL syntax error under Lucee. This was a large part of the reason we couldn't switch the app over to Lucee.

Example 1:

Results:

  • Lucee 5: {ts '2017-05-18 19:14:38'}

  • ACF 11: 2017-05-18 19:14:38.343

Example 2:

DDL:
CREATE TABLE SomeTable ( DateTimeColumn DATETIME )

Query:

Results:

  • ACF 11: Record is inserted successfully

  • Lucee 5.0.0.252 : Insert fails with syntax error:

Status

Assignee

Michael Offner

Reporter

Leigh

Labels

None

Priority

Minor
Configure