convert TimeStamp

[praburaj]

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.

[chulett]

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.

[meena]

Hi Chulett
Can we do something like this too:

Code: Select all

 
 Oconv(Iconv(i/p,"D/MDY[2,2,4]"),"D-DMY[,A,]") 
 

I want to check whether it is possible or not.

Thank you.

[chulett]

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.

[meena]

Thank you Chulett. I got it..

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.

[praburaj]

Hai meena,

I am using my source is a timestamp. If u got it, How can u do that?

can u help me

Regards,

prabu

[loveojha2]

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.

That answers everything. Doesn't that?
Did you try what chulett suggested?
What result you got?