ColdFusion Server (5 and 4.5.x) with Oracle: Formatting Date and Time Query Results
This article discusses how to ensure that your date and time values are formatted consistently, no matter what database you're using. Since database query results for date and time values can vary in appearance (sequence and formatting), Macromedia recommends that you always use the DateFormat and TimeFormat functions to format date and time values from queries. The article features code for different Oracle drivers.
ColdFusion Server (5 and 4.5.x) with Oracle: Formatting Date and Time Query Results