|
From: lacapu <lac...@ya...> - 2008-05-05 18:33:30
|
Thanks to the suggestions by Robert from this forum, I've resolved the problem. The problem had to do with the jdbc thin driver that I was using from the classes12.zip. It was an older jdbc and it wasn't JDBC 3.0 complaint. Once I replaced the classes12.zip that came with my Oracle installation, SQuirreL did show up the time on the "TIMESTAMP(6)" type column of my table. Thanks again to all for your emails and suggestions! lacapu wrote: > > Hi. I'm using the oracle thin driver to connect to my Oracle database > (oracle.jdbc.driver.OracleDirver). When I do a query on a table that has a > column of type of TIMESTAMP(6), the output of the column does not show the > time of each of the record; but rather SQuirrel shows the content of that > column as: > <Unknonw(-100)> > > However, when I use sqlplus, I can see the time just fine. Can someone > tell me what is the settings or whatever that I need to do in order to see > the right time in a field/column of type TIMESTAMP(6). > > Thanks in advanced! > -- View this message in context: http://www.nabble.com/Why-SQuirrel-won%27t-display-the-time-for-an-Oracle-database--tp17029083p17067927.html Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
