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 ]
I'm not dead! I feel happy! I'd like to go for a walk! I'll even read a tiny ad: