|
From: anisah <ani...@ya...> - 2008-09-30 02:41:28
|
anisah wrote: > > Hi Robert, > OK actually I got the latest classes12.zip and its JDBC 3 compliance. But > I notice that when I imported a file with date for eg. "1/04/2008 > 7:00:11 AM", it shows in squirrels as "4/1/08 12:00 AM" > Could you kindly assist as to how could i get the same timing as the > original data. > Thank you > > > Hi Robert > I am facing the same problem. Could you kindly let me know where could i > download this classes12.zip. > Or could you email me this classess12.zip file. > Thank you. > Anisah > > > > lacapu wrote: >> >> 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--tp17029083p19735240.html Sent from the squirrel-sql-users mailing list archive at Nabble.com. |
