Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.oracle    |    Overblown overpriced overengineered SHIT    |    2,288 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 1,988 of 2,288    |
|    Spare Brain to All    |
|    Can you help me with JDBC getDate() erro    |
|    01 Feb 05 20:34:37    |
   
   XPost: comp.databases.oracle.misc, comp.databases.oracle.server,   
   comp.lang.java.databases   
   From: spare_brain@yahoo.com   
      
   Hi,   
      
   I am observing a strange error with the time portion of the java.sql.Date()   
   when using resultSet.getDate() - it always seems to show 12:00:00.   
      
   The following code prints 2004-10-27 11:00:00.0   
      
    String dtStr = resultset.getString("PROMISEDATE");   
    System.out.println(dtStr);   
      
   The following code prints 2004-10-27 12:00:00   
    java.util.Date dt = resultset.getDate("PROMISEDATE");   
    System.out.println(new SimpleDateFormat("yyyy-MM-dd   
   hh:mm:ss").format(dt));   
      
   Any clue why the getDate screws up the time? Any remedies you may suggest?   
      
   Many thanks   
   SB   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   
|
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca