Date Format

[Former Member]

Hi Guys,

I need to change the date format from

2007-10-11T05:14:35.0000000-05:00Z

2007-10-11T05:14:35.0000000Z with ouy -05.00Z. I have used sub string but no result.

any help would be appreciated

Thanks,

srini

[Former Member]

HI,

Use Datetrans funtion,try with this if u dont get update the thread.

Regards,

phani

[Former Member]

Hi Guys,

I tried with the Date Trans but not meeting the requirement, i think in the date trans

i declares the source as yyyy-MM-ddTHH:mm:ss.SSSSSSSZ

Target as yyyy-MM-ddTHH:mm:ss:SSSSSSS

How to handle T in date trans

any help would be appreciated

Thanks,

srini

[VijayKonam]

Srinivas,

I dont think, DATETRAN function can hanlde time zones. You might have to write a simple UDF which can remove the unwanted chanracter. If you feel that, the position of these unwanted characters is constant all the time, you can fetch them from with in the string using char postion indeces.

VJ

[Former Member]

Hi

you can use the datetranform function provided in the standard date functions

Thanks

Rinku

[Former Member]

Hi Srinivas kapu

Use the standard DATE function..we have a option

Use Date Function in Message Mapping.There are a variety of options available to which you can change your incoming date.

Use Date Trans Standard Function in Mapping Editor

Right Click on that -Goto Properties-Do Changes What ever U Want

check with these threads also

Thanks !!

[santhosh_kumarv]

Hi Srinivas,

Use the date trans funtion.

Regards

San