Re: [INTERFACES] Re: ResultSet.getDate

Hi All! :-)

Here is an even better one for you! ;-) It seems that
Java, not JDBC is chopping the time portion in doing
the conversion from a java.util.Date to a java.sql.Date
(ResultSet.getDate converts them) Try the following,
please :

import java.sql.* ;
import java.text.* ;
import java.util.* ;

class DateTest
{
// Public Methods
public static void main ( String strgarrArgs [] )
{
try
{
SimpleDateFormat sdf = new SimpleDateFormat ( "dd MMM yyyy
HH:mm:ss" ) ;
java.util.Date date = new java.util.Date ( "01 Feb 1999
16:08:00" ) ;
System.out.println ( "\nDate is:\t" + sdf.format ( date ) ) ;
java.sql.Date sqldate = new java.sql.Date ( date.getTime ()
) ;
System.out.println ( "SQL Date is:\t" + sdf.format ( sqldate )
+ "\n" ) ;

} /* endtry */
catch ( Exception e )
{
System.out.println ( "\nCaught an Exception of type " +
e.getClass ().getName () ) ;
System.out.println ( e.getMessage () ) ;

} /* endcatch */

} /* static void main ( String strgarrArgs [] ) */

} /* class DateTest */

On my machine at least the output is :

Date is: 01 Feb 1999 16:08:00
SQL Date is: 01 Feb 1999 00:00:00

Looks like a definite bug in the JVM or just in the
Blackdown Linux v1.17 JVM! ;-) Thanks again!

==
Peace,
Peter

We are Microsoft of Borg, you will be assimilated!!!
Resistance is fut... ***BZZZRT*** THUD!!!
[General Protection Fault in MSBorg32.DLL]
Please contact the vendor for more information
_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com