|
From: Robert M. <rob...@gm...> - 2009-03-20 01:36:27
|
I was able to reproduce this. Yes you configure the local timezone in the Oracle global preferences tab. But, you also need to ensure that ojdbc14.jar is in the classpath for SQuirreL. The easiest way to do this (if you launch with squirrel-sql.bat or squirrel-sql.sh) is to copy ojdbc14.jar into SQUIRREL_HOME/lib directory. Then it should work. Rob On Thu, Mar 19, 2009 at 5:38 PM, Wang, Tony <Ton...@ar...> wrote: > I have also found that under Global Preferneces->Oracle->Initialize Session Time is set to "America/Los Angeles". > > But it still returns <Error> for "Timestamp with local time zone" data type. > > -----Original Message----- > From: Wang, Tony > Sent: Thursday, March 19, 2009 2:26 PM > To: Robert Manning > Cc: squ...@li... > Subject: Re: [Squirrel-sql-users] Squirrel show <Error> to Oracle timestamp with local time zone" data type > > Hi Rob, > > I have downloaded the newest Squirrel SQL Client 3.0 standard and optional files. Where and how do I configure it? > > I tried to write a "alter session set time_zone='America/Los_Angeles'" under Plugins/Session Scripts... > > Then I issued the select * from test and got the same result. > > According to Oracle Plugins Change Log > ================= > > 0.20 > ==== > - Bug #1844898 (TIMESTAMP(6) WITH LOCAL TIME ZONE shows <Error>) > > It should work. > > Please help. > > Thanks, > Tony > > -----Original Message----- > From: Robert Manning [mailto:rob...@gm...] > Sent: Thursday, March 19, 2009 11:43 AM > To: Wang, Tony > Cc: squ...@li... > Subject: Re: [Squirrel-sql-users] Squirrel show <Error> to Oracle timestamp with local time zone" data type > > I believe there is a configuration for this with the Oracle plugin in > 3.0. I don't think it is available for 2.6.x. > > Rob > > On 3/19/09, Wang, Tony <Ton...@ar...> wrote: >> >> >> >> Hi All, >> >> >> >> Does anyone know if Squirrel SQL Client supports Oracle "timestamp with >> local time zone" data type? >> >> >> >> I am using Squirrel SQL Client 2.6.7 and the Database I am accessing is >> Oracle 10g 10.2.0.3.0. >> >> >> >> There is a table defined as: >> >> >> >> CREATE TABLE test ( >> >> id Number NOT NULL, >> >> creation_time TIMESTAMP(3) WITH LOCAL TIME ZONE NOT NULL >> >> ) >> >> >> >> Insert into test(id, creation_time) values (1, timestamp '2009-03-19 >> 00:00:00') >> >> >> >> If you query the table by "select * from test" >> >> >> >> Squirrel will return : >> >> >> >> 1 <Error> >> >> >> >> I believe that session time zone is not set in Squirrel. Does anyone know >> how to show the creation_time correctly? >> >> >> >> Thanks, >> >> Tony >> ------------------------------------------------------------------------------ >> Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are >> powering Web 2.0 with engaging, cross-platform capabilities. Quickly and >> easily build your RIAs with Flex Builder, the Eclipse(TM)based development >> software that enables intelligent coding and step-through debugging. >> Download the free 60 day trial. >> http://p.sf.net/sfu/www-adobe-com >> _______________________________________________ >> Squirrel-sql-users mailing list >> Squ...@li... >> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users >> >> > > ------------------------------------------------------------------------------ > Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are > powering Web 2.0 with engaging, cross-platform capabilities. Quickly and > easily build your RIAs with Flex Builder, the Eclipse(TM)based development > software that enables intelligent coding and step-through debugging. > Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users > |
