9 Replies Latest reply on Jul 2, 2008 12:49 PM by cfquest

    Format Oracle Date to CF Output

    cfquest Level 1
      I'm querying an Oracle db and one of the fields is a date field. I am selecting many columns from this db so have tried many different versions of either DateFormat, Oracle's TO_DATE and TO_CHAR conversions but none of them worked successfully. I think what is throwing me off is that I'm not just selecting the date field, I'm selecting many fields so I've even tried a query of query with no luck.

      Any help will be greatly appreciated.