8 Replies Latest reply on Jan 29, 2013 5:52 AM by WolfShade

    Oracle 10g - Date format in SELECT query for CFOUTPUT

    WolfShade Level 4

      Hello, everyone.


      The project that I am working on in the dev environment is connected to an Oracle 11g database, but the production side is Oracle 10g.


      I have a page that is erroring in production (but not development) when it gets to a date that it needs to display.


      A co-worker mentioned that, in 10g, if a date/time is being SELECTed, you have to put it in to_char(), so I did that.


      But it's still erroring, and I'm not getting an error message, so I'm assuming that I have an incorrect format for the date in the SELECT.


      What is the proper format for SELECTing a date/time when using to_char()?  Right now, I have SELECT to_char(create_date,'MM-DD-YYYY HH:MI') FROM tableA .  Is this not correct for CF to output?


      Thank you,