Always Applying Date Mask on cfquery (MySQL)

[iMadDeveloper]

ColdFusion is displaying my dates in an incorrect timestamp format. I
understand that the date can be masked using the DateFormat() function, but
since the queries are dynamically being generated and displayed I don't know
the data type of the information without making an additional call to the
information_schema in MySQL. Is there a way to tell ColdFusion to always
display any date/time formats with a specific mask?

[mxstu]

If you're using MX7, you could use the GetMetaData() function to return the data types of the columns in the cfquery and then use dateFormat() if the dynamic column is a date/time column.