This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
how to retrieve datetime with result; if i use rs.getDate("CREATE_DATE") i am getting numberformat exception?i am using oracle database? i want in this format 12-Jul-2003 14:20 format??? can anybody give me code SELECT TO_CHAR(CREATE_DATE, 'DD-MON-YYYY HH24:MI') AS CREATE_DATE FROM COMPLAINT_DETAILS A,COMPLAINT_MASTER B, OFFICE_HIRARCHY C,CONSUMER_MASTER D,USER_MASTER E WHERE RECORD_STATUS='ACTIVE'
Another option would be to use rs.getString("CREATE_DATE") instead of rs.getDate("CREATE_DATE"), as the TO_CHAR function probably returns a String. -Paulo [ July 25, 2003: Message edited by: Paulo Salgado ] [ July 25, 2003: Message edited by: Paulo Salgado ]