Getting Time Zone Offset from Oracle

  • Thread starter Thread starter jpabich
  • Start date Start date
J

jpabich

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!
*************************************************
 
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.
 
Back
Top