XPost: comp.databases.oracle.misc, comp.databases.oracle.server,   
   comp.lang.java.databases   
   From: joeNOSPAM@bea.com   
      
   Spare Brain wrote:   
      
   > 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?   
      
   Yes, because it's a Date (date only). Try getTimestamp().   
   Joe Weinstein at BEA   
      
      
   >   
   > Many thanks   
   > SB   
   >   
   >   
   >   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)