Re: [cx-oracle-users] Getting timezone info out of systimestamp

[Anthony T. <ant...@gm...>]

I am currently ignoring timezone stuff completely within cx_Oracle --
a lot of that seems black magic to me which is why I haven't attempted
it. :-) Are there any other modules that have implemented this sort of
thing? I know you can get at the timezone for the session by "select
sessiontimezone from dual". If you know what to do with that perhaps I
can add the code to cx_Oracle -- naturally Oracle has a different
concept of time zones than Python does which makes it a little more
difficult. Comments?

On 5/9/06, Walter D=F6rwald <wa...@li...> wrote:
> Hello list!
>
> Is there a way to get the timezone information out of systimestamp? The
> following code doesn't seem to work:
>
> In [1]: import cx_Oracle
> In [2]: db =3D cx_Oracle.connect("...")
> In [3]: c =3D db.cursor()
> In [4]: c.execute("select systimestamp from dual")
> Out[4]: [<cx_Oracle.TIMESTAMP object at 0xb3aa62a0>]
> In [5]: d =3D c.fetchone()
> In [6]: d[0].tzinfo
> In [7]:
>
> I'm using Python 2.4.2/cx_Oracle 4.1.2
>
> Servus,
>    Walter
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job ea=
sier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronim=
o
> http://sel.as-us.falkag.net/sel?cmd=3Dlnk&kid=3D120709&bid=3D263057&dat=
=3D121642
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>