• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

problem retrieving datetime

 
kesava chaitanya
Greenhorn
Posts: 28
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi

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'
 
SJ Adnams
Ranch Hand
Posts: 925
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
replace "TO_CHAR(CREATE_DATE, 'DD-MON-YYYY HH24:MI') AS CREATE_DATE " with "CREATE_DATE"
 
Paulo Salgado
Ranch Hand
Posts: 98
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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 ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic