Queries of date fields are returned with timestamp in ColdFusion MX

(TechNote) As of ColdFusion MX, queries on date fields return the date as it is stored in your database, including any timestamps. This is a change in functionality from ColdFusion 5, which returned a formatted date field when using certain database drivers.