Hi
I am extarcting data from a table in oracle. One of the column is having a datatype as TIMESTAMP(6) WITH LOCAL TIME ZONE. When i query the oracle at sqlplus promt i get the column value as
select Open_date from open_tckt where ref_num = 'IN26'
2 /
OPEN_DATE
---------------------------------------------------------------------------
29-SEP-07 05.45.45.000000 AM
for this column i have given the column datatype as timestamp in datastage. I have used the oracle enterprise stage for extraction.
But when i view the data in datastage , the same value appears to be 6 hours ahead i.e. 2007-09-29 11:45:45 AM
I have executed the below command at sqlplus prompt. The timezone is GMT - 6. --------------------------------------------------------------------------------
select to_char(sysTIMESTAMP,'HH24:MI:SS.FF TZH:TZM') from dual;
TO_CHAR(SYSTIMESTAMP,'HH2
-------------------------
07:49:10.657667 -06:00
--------------------------------------------------------------------------------
So datastage is presenting the date in GMT instead of shwoing me in GMT-6
Any ideas how to show the time in original timezone in oracle instead of GMT timezone ?
TIMESTAMP(6) WITH LOCAL TIME ZONE datatype
Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett, rschirm, roy
Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration