Re: 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/