Re: Oracle nls_date_format

It's intentional by Oracle to not return the time with the current Oracle
JDBC driver. It's also highly annoying to lots of folks that Oracle made
this change in their 9.2 release.

A workaround is to use an older Oracle JDBC driver. Or you can simulate
using an older driver by adding something like this to your startup
params:

java -Doracle.jdbc.V8Compatible="true"

There good info here in the section "What is going on with DATE and
TIMESTAMP?"
http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm

Regards,
Matt Dahlman
 

-----Original Message-----
From: squirrel-sql-users-bounces@xxxxxxxxxxxxxxxxxxxxx
[mailto:squirrel-sql-users-bounces@xxxxxxxxxxxxxxxxxxxxx] On Behalf Of
Robert Manning
Sent: Friday, 19 October, 2007 11:36
To: Frank Brendel
Cc: squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
Subject: Re: [Squirrel-sql-users] Oracle nls_date_format

On 10/19/07, Frank Brendel <frank.brendel@xxxxxxxxxxx> wrote:
> Hi Rob,
>
> thanks for your help.
>
> >
> > There is a work-around if you prefer not to use the "correct" data 
> > type (timestamp) to store a time component along with the date.  In 
> > Global Preferences -> DataType Controls -> Date section you can 
> > check "treat DATE as TIMESTAMP" which will cause SQuirreL to 
> > retrieve all java.sql.Date as java.sql.Timestamp instead.  Note 
> > however, that while this works fine for Oracle, I've seen it not 
> > work so well for a database that implements SQL according to the 
> > standard.  So be careful with this setting if you also access
non-Oracle databases.
> >
>
> I've changed the java code to use java.sql.Date resp. 
> java.sql.Timestamp and it works as you have said. Date gives me 
> '2007-10-19' and Timestamp '2007-10-19 15:35:49.0'.

Oh, no actually I was referring to the Table column type.  Most people
refuse to convert their table columns from DATES to TIMESTAMP,
understandably so.  So the "Treat DATE as TIMESTAMP" is used for this
purpose.   It changes SQuirreL's java code to use getTimestamp() which
returns java.sql.Timestamp instead of getDate() which returns
java.sql.Date.

Rob
Rob

-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users


-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems?  Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/