Issue with Timezone in flat files
Posted: Mon May 09, 2016 4:56 am
Hi All,
Could you please help me in providing your solution for the below scenario:
We are using Oracle table as source and we have the date format coming from the source as below.
01-JAN-00 12.00.01.000000000 AM -5:00
We are trying to load the date format as it is including the timezone into a flat file. We are using a sequential file stage for this.
While doing this, we are having the timestamp format loaded ,however, the timezone part "-5"00" is getting truncated and we are not able to load it.
However,when we try to use a dataset in a target or any other oracle table, we are able to get the timestamp as it is as expected.
Could you please suggest how can we retrieve the time zone information.
FYI, we have used different flat file formats (.dat,.csv..xls etc) and also tried different timestamp formats in the sequential file stage options,but invain.
Besides, FYI, we have the NLS option disabled for the datastage project.
Please suggest.
Could you please help me in providing your solution for the below scenario:
We are using Oracle table as source and we have the date format coming from the source as below.
01-JAN-00 12.00.01.000000000 AM -5:00
We are trying to load the date format as it is including the timezone into a flat file. We are using a sequential file stage for this.
While doing this, we are having the timestamp format loaded ,however, the timezone part "-5"00" is getting truncated and we are not able to load it.
However,when we try to use a dataset in a target or any other oracle table, we are able to get the timestamp as it is as expected.
Could you please suggest how can we retrieve the time zone information.
FYI, we have used different flat file formats (.dat,.csv..xls etc) and also tried different timestamp formats in the sequential file stage options,but invain.
Besides, FYI, we have the NLS option disabled for the datastage project.
Please suggest.