Getting Time Zone Offset from Oracle

I am trying to get the time zone offset value that is stored in an
oracle database field of type TimeStamp with TimeZone. I can see the
value in the database column. However, when I run the query and get it
back to .NET, the offset seems to be gone. How do I get this value
from Oracle to .NET?

There is no native control in .NET that has the offset. The one possible
method is by sticking with the Oracle DB objects, which may require ODP.NET
from Oracle. If not, you will have to pull the offset separately and supply
it in the select statement. A pain, yes, but it will guarantee the value
gets through. I you ha INSERT/UPDATE capabilities on the field, you will
have to reconstiitute on the way back in.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

*************************************************
Think outside of the box!
*************************************************
"jpabich" <jpabich@eisincorporated.com> wrote in message
news:1158585479.055063.144030@b28g2000cwb.googlegroups.com...
>I am trying to get the time zone offset value that is stored in an
> oracle database field of type TimeStamp with TimeZone. I can see the
> value in the database column. However, when I run the query and get it
> back to .NET, the offset seems to be gone. How do I get this value
> from Oracle to .NET?
>

How would I use an SQL statement to pull it off separately ? I have
been looking for this all over, but can't find it.



Cowboy (Gregory A. Beamer) wrote:
> There is no native control in .NET that has the offset. The one possible
> method is by sticking with the Oracle DB objects, which may require ODP.NET
> from Oracle. If not, you will have to pull the offset separately and supply
> it in the select statement. A pain, yes, but it will guarantee the value
> gets through. I you ha INSERT/UPDATE capabilities on the field, you will
> have to reconstiitute on the way back in.
>
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
>
> *************************************************
> Think outside of the box!
> *************************************************
> "jpabich" <jpabich@eisincorporated.com> wrote in message
> news:1158585479.055063.144030@b28g2000cwb.googlegroups.com...
> >I am trying to get the time zone offset value that is stored in an
> > oracle database field of type TimeStamp with TimeZone. I can see the
> > value in the database column. However, when I run the query and get it
> > back to .NET, the offset seems to be gone. How do I get this value
> > from Oracle to .NET?
> >