ColdFusion is typless this make's lots of things easy but when creating a new query we have to be careful as occasionally ColdFusion will do it's own thing and "type" a column as the wrong "type" ie treat a date/time as a string for example.
We had an instance of this recently which is not easily reproducible but was fixed by forcing column to "timeStamp".
While searching for the cause of this I used the ColdFusion docs to ensure I was using the right types and well according to the docs type "date" shoudl allow date and time information but it did not. I was a bit dissapointed to see this wasn't working as intended and i really wanted a type of "dateTime" which didn't exist according to Adobe. So I tried anyway and got this error message which put me on the right path.
Type "timeStamp" exists and worked perfectly but is not mentioned in the doc's.
Here is a demo:
URL: http://cf9.kukiel.net/demos/querynew
Here is the link to the ColdFusion docs:
http://help.adobe.com/en_US/ColdFusion/9.0/CFMLRef/WSc3ff6d0ea77859461172e0811cbec22c24-7f94.html




