Re: Oracle Dates and Java Dates and selecting the former into the later

From: <mike.jones_at_xenicom.com>
Date: 2 Jun 2005 02:01:47 -0700
Message-ID: <1117702907.115517.274650@f14g2000cwb.googlegroups.com>

Good points, Liked the default date format idea (hadn't thought about that). Alas it makes no odds.

It appears to be to do with the Oracle drivers we are using, if we use

oracle.jdbc.driver.OracleDriver then "Select sysdate from dual" returns
a java.sql.timestamp.  However if we use
oracle.jdbc.xa.client.OracleXADataSource (Which we are) then we get

back a java.sql.date and that doesn't have a time element as per the standard.

Any ideas? I'm getting a bit lost...

Mike. Received on Thu Jun 02 2005 - 04:01:47 CDT

This message: [ Message body ]
Next message: Spendius: "Re: SQL definition of grid metrics: where is it stored ?"
Previous message: gonkowonko_at_gmail.com: "Re: Linking SQL Server tables to Oracle Tables DSN-Less"
In reply to: Frank van Bortel: "Re: Oracle Dates and Java Dates and selecting the former into the later"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US