Date conversion problem
Moderators: chulett, rschirm, roy
Date conversion problem
Hello DS Friends,
In my job , source and target are oracle tables .source having portfoliodate column and its datatype is TIMESTAMP. for ex its value is 1998-01-31 00:00:00 . while conveting portfoliodate(Timestamp) into target date(dd-mon-yy) format I am using following Iconv,Oconv function.
1)Substrings(DSLink4.PORTFOLIODATE,1,10)
2)Oconv(Iconv(aa, "D-YMD"), "D-DMY[,A3,2]") .
While running job , i am getting following warnig in every portfoliodate values : "Graph_CSV_sf_Test..Transformer_1: At row 2333, link "DSLink5", while processing column "PortfolioDate"
Value treated as NULL
Attempt to convert String value "31-Jan-98" to Date type unsuccessful"
why value treats as Null that i am not getting, Please share your ideas on this issue.
Thanks
HHH
In my job , source and target are oracle tables .source having portfoliodate column and its datatype is TIMESTAMP. for ex its value is 1998-01-31 00:00:00 . while conveting portfoliodate(Timestamp) into target date(dd-mon-yy) format I am using following Iconv,Oconv function.
1)Substrings(DSLink4.PORTFOLIODATE,1,10)
2)Oconv(Iconv(aa, "D-YMD"), "D-DMY[,A3,2]") .
While running job , i am getting following warnig in every portfoliodate values : "Graph_CSV_sf_Test..Transformer_1: At row 2333, link "DSLink5", while processing column "PortfolioDate"
Value treated as NULL
Attempt to convert String value "31-Jan-98" to Date type unsuccessful"
why value treats as Null that i am not getting, Please share your ideas on this issue.
Thanks
HHH
Yes,default format of date in oracle is dd-mon-yy only, i hv checked it from dual.
However here , portfoliodate has been converted to default format only.
However here , portfoliodate has been converted to default format only.
ArndW wrote:Are you sure that your default date format is being used? Execute a SQL "SELECT sysdate from dual;" using your favorite tool and see if that format matches yours. ...
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
-
- Participant
- Posts: 232
- Joined: Fri Sep 30, 2005 4:52 am
- Contact:
-
- Participant
- Posts: 22
- Joined: Thu Jun 02, 2005 5:12 am
Re: Date conversion problem
Your 'default' or NLS_DATE format don't come into play if you are treating these fields as dates. If you are using OCI stages with Generated SQL and a Timestamp datatype, (which you should be, in my opinion) then your incoming value is already in the proper format for the target.hhh wrote:In my job , source and target are oracle tables .source having portfoliodate column and its datatype is TIMESTAMP. for ex its value is 1998-01-31 00:00:00 . while conveting portfoliodate(Timestamp) into target date(dd-mon-yy) format I am using following Iconv,Oconv function.
Drop your substring/Conv transformations and just push the portfoliodate over untouched.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Hi all,
As i am new to Datastage, I want to know that the Functions "Iconv and Oconv" works in Parallel Extender jobs or not.
If not which is the equivalent function to this in parallel jobs.
Please ppl help me out.
thanks in advance
As i am new to Datastage, I want to know that the Functions "Iconv and Oconv" works in Parallel Extender jobs or not.
If not which is the equivalent function to this in parallel jobs.
Please ppl help me out.
thanks in advance
Raji
Nothing is impossible because impossible itself
says I'm Possible
Nothing is impossible because impossible itself
says I'm Possible
-
- Participant
- Posts: 48
- Joined: Sat Oct 22, 2005 9:56 am
Could any one of you let me know parallel forum Link
Hi Balajisr,
Could you let me know parallel forum link.
Could you let me know parallel forum link.
Plot No – B4, Jeevan Akshyay apts
8/14, 2nd Main Road, Jaya Nagar
Tambaram sanitorium,
Chennai-47.
smandepudi@gmail.com
8/14, 2nd Main Road, Jaya Nagar
Tambaram sanitorium,
Chennai-47.
smandepudi@gmail.com
Re: Could any one of you let me know parallel forum Link
sateeshbabu wrote:Hi Balajisr,
Could you let me know parallel forum link.
Click on the Forum link on the top of the page. You will get list of forums. Parallel forum is the next link to Server Forum. Parallel forum is same as Enterprise edition forum.
viewforum.php?f=8