home bbs files messages ]

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