Kenneth Lo
2004-10-26 20:56:03 UTC
Background:
I'm running SQuirrel 1.2 beta 6, using Oracle jdbc thin driver (download
from their site) 9.0.1 (class12.jar). My oracle datebase is Oracle 9i.
Right now I can't output from a query looking at a date column returns
"<unknown(-100)>".
I spoke with my DBA and she said that all our database's date datatype
use "TIMESTAMP with local time zone", and there are some additional
setup/code change/plugin might needed on the sql client. Any insight?
TIA.
--Kenneth Lo
I'm running SQuirrel 1.2 beta 6, using Oracle jdbc thin driver (download
from their site) 9.0.1 (class12.jar). My oracle datebase is Oracle 9i.
Right now I can't output from a query looking at a date column returns
"<unknown(-100)>".
I spoke with my DBA and she said that all our database's date datatype
use "TIMESTAMP with local time zone", and there are some additional
setup/code change/plugin might needed on the sql client. Any insight?
TIA.
--Kenneth Lo