Hi Team,
I am using below below query in oracle connector in my parallel job in order to get yaer and month from date.
select to_char(DATE_COLUMN,'YYYYMM') from table_name.
While running facing error:literal does not match format string.
If i run same query in oracle datbase its working,not sure why datastage throwing fatal error.
Please help,cause i need to compare this to a numeric field from another table which contains year and month ex: 201308
Date Format Error in parallel job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 30
- Joined: Wed May 15, 2013 1:22 am
- Location: Bangalore
Date Format Error in parallel job
Cheers,
Schindler
Schindler
What is your column defined as in DataStage? I would explicitly name the column, as below:
and define DataStageColumn as char with fixed length 6.
Code: Select all
select to_char(DATE_COLUMN,'YYYYMM') as DataStageColumn from table_name
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 30
- Joined: Wed May 15, 2013 1:22 am
- Location: Bangalore