Geek Answers Handbook

Various query results returned in Coldfusion versions

We run cfquery in two different versions of ColdFusion (CF9 and CF10). When the results are returned, the dates are formatted differently in separate versions.

Request

SELECT TOP 100 CONVERT(DATE,Field1,121),Field2
FROM A_TABLE

In CF9, returning field 1 looks like 2010-06-01.

In Cf10, returning field 1 looks like {ts '2010-06-01 00:00:00'}

Has anyone else noticed this difference? We searched the CF documentation and did not notice any mention of this change.

+4
source share
1 answer

The returned data is the same. What you see in CF10 is how ColdFusion displays date / time objects. (edited based on reviews from Miguel-F)

, /, ( ) dateFormat(), timeformat() ( CF 10 datetimeformat()) / .

+6

More articles:


All Articles