on 03-27-2008 5:12 AM
Hi experts,
I am following the fllowing blog for date format conversion for a jdbc receiver.
/people/alessandro.berta/blog/2005/10/04/datetime-datatypes-and-oracle-database
I constructed my graphical mapping to generate the following query
DateField in receiver structure = TO_DATE('2008-03-24','DD-MON-YY')
attribute hasQuot = No
The result that i want is 24-MAR-08
I am getting the error in communication channel monitoring as does not match string format.
The database gets successfully updated without this date conversion. But when i try to use this, it give the above error.
Is there any other configuration to be done to make the adapter execute this statement?
Regards,
Shamly
The issue is solved.
The SQL statement was wrong.
The correct version is,( as was specified in the blog ) :-
DateField in receiver structure = TO_DATE('2008-03-24','YYYY-MM-DD')
Automatically in the database it is converted to 24-MAR-2008
Edited by: Shamly MM on Mar 27, 2008 8:01 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.