Coldfusion 9 + SQL server 2008 datetime returns binary

I have a very simple开发者_JAVA百科 query written in coldfusion 9. I have a datetime field that I am selecting, for some odd reason the query returns it as binary instead of as a date.

Is there a work around for this that does not require me to cast the date as a char.

You could try using ToString(), then creating a Date/Time object using the CreateODBCDateTime() function...