Hai,
I have one problem.
My Source column is
AGG_EFF_SOURCE_DATE
AGG_EFF_END_DATE
This Column Datatype is Time Stamp. Here, my condition is i need
convert Time Stamp DataType (MM/DD/YYYY HH:MM:SS) in to (DD-MON-
YYY).
EX:
INPUT:
03/15/2006
OUTPUT:
15-FEB-2006.
In my job i am using
OCISTAGE_SOURCE, TRANSFROMER,OCI_TARGET
How Can I do that. Can any one help me.
Regards,
prabu.
convert TimeStamp
Moderators: chulett, rschirm, roy
Hi Chulett
Can we do something like this too:
I want to check whether it is possible or not.
Thank you.
Can we do something like this too:
Code: Select all
Oconv(Iconv(i/p,"D/MDY[2,2,4]"),"D-DMY[,A,]")
Thank you.
Sure, it's possible - just completely unnecessary.
If you do it, make sure you use the right format mask on the target side. Or the dangerous practice of using a varchar and matching the default date format for your target. It may work, but is a Very Bad Practice as far as I'm concerned.
![Confused :?](./images/smilies/icon_confused.gif)
If you do it, make sure you use the right format mask on the target side. Or the dangerous practice of using a varchar and matching the default date format for your target. It may work, but is a Very Bad Practice as far as I'm concerned.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Thank you Chulett. I got it..
chulett wrote:Sure, it's possible - just completely unnecessary.![]()
If you do it, make sure you use the right format mask on the target side. Or the dangerous practice of using a varchar and matching the default date format for your target. It may work, but is a Very Bad Practice as far as I'm concerned.
That answers everything. Doesn't that?chulett wrote:You don't need to 'convert' anything. Simply declare the datatype for the Oracle DATE field as Timestamp on both source and target, let the stages generate the sql and you'll be fine.
Did you try what chulett suggested?
What result you got?
Success consists of getting up just one more time than you fall.