Question Re: Date Time conversion in Technology Q&A

Date Time conversion

former_member237514 — Thu, 08 Sep 2016 05:33:38 GMT

Hi All,

i am getting below error using date transformation function.

Client expected :2016-01-01T00:00:00-08:00

same format i maintain in graphical mapping level below is the screen shot

but when i test the total scenario with sample data i am getting below error .

Plz give some suggestions ASAP.

Thanks

Kavitha

Re: Date Time conversion

Former Member — Thu, 08 Sep 2016 05:44:48 GMT

HI Kavitha,

please change your data type for "ValidFrom" field from string to Date and try.

Regards,
Bhavin Parmar

Re: Date Time conversion

former_member237514 — Thu, 08 Sep 2016 05:50:25 GMT

Hi Bhavin,

In sender and receiver side structure i can able to see the data type as "String" for "ValidFrom" field.

Below is the screen shot fyi,

Plz check end let me know any suggestions

Thanks

Kavitha

Re: Date Time conversion

Former Member — Thu, 08 Sep 2016 05:54:21 GMT

Hello Kavitha,

Try with the patterns as per the below link

SimpleDateFormat (Java Platform SE 7 )

Re: Date Time conversion

Former Member — Thu, 08 Sep 2016 05:56:37 GMT

Hi Kavi,

The S symbol is used for milliseconds, have you checked this blog ?

Regards,

Re: Date Time conversion

former_member190293 — Thu, 08 Sep 2016 05:58:04 GMT

Hi Kavi!

Take a look at 's blog.

I guess that standard function "DateTrans" doesn't support your output date format.

Try with output format like yyyy-MM-dd'T'HH:mm:ss Z.

Regards, Evgeniy.

Re: Date Time conversion

former_member237514 — Thu, 08 Sep 2016 06:16:14 GMT

Hello Raghu,

I gone through the link which you provide earlier .

here i have one more doubt

Target excepting :1900-01-01T00:00:00-08:00

In mapping level I applied this syntax format "yyMMddHHmmssZ" 010704120856-0700

i got the output like 2016-07-20T00:00:00+0000.

But here end of the of the date i need +00:00 like this.

Can you help me this .how to get .

Thanks

Kavitha

Re: Date Time conversion

Former Member — Thu, 08 Sep 2016 06:24:30 GMT

Hello Kavitha,

You dont need + 0.00 right?

Try like below

yyyy-MM-dd'T'HH:mm:ss.SS

Where SS stands for milliseconds ,you can add one more S if you wish to have 3 digit millisecond value.

Re: Date Time conversion

former_member237514 — Thu, 08 Sep 2016 06:43:32 GMT

Hi Raghu,

kindly find the below screenshot

I tried with adding X format Date also but i got error.

Re: Date Time conversion

Former Member — Thu, 08 Sep 2016 06:45:48 GMT

Hello Kavitha,

Post the exact format required.

You need to add timezone or milliseconds.

Re: Date Time conversion

former_member237514 — Thu, 08 Sep 2016 06:56:18 GMT

Client expected :2016-01-01T00:00:00-08:00

in that client requirement end of the digits(-08:00) regarding Timezone.

so i need time zone formate

I got upto 2016-07-20T00:00:00+0000 but end of the digits (+0000) i need to put semicolon like +00:00

so plz suggest me how to do that

Re: Date Time conversion

Former Member — Thu, 08 Sep 2016 07:02:22 GMT

Hello Kavitha,

Try either of the the below

yyyy-MM-dd'T'HH:mm:ss.SSSZ

yyyy-MM-dd'T'HH:mm:ss.SSSXXX

Re: Date Time conversion

former_member237514 — Thu, 08 Sep 2016 07:20:42 GMT

Hello Raghu,

I tried with your inputs

yyyy-MM-dd'T'HH:mm:ss.SSSZ for this output 2016-07-20T00:00:00.000+0000

yyyy-MM-dd'T'HH:mm:ss.SSSXXX for this output i am getting error like below screen shot.

Re: Date Time conversion

Former Member — Thu, 08 Sep 2016 07:28:46 GMT

Hello Kavitha,

XXX is only to get timezone with Semicolon,

Can you post the screenshot with input and outputs.

Re: Date Time conversion

former_member237514 — Thu, 08 Sep 2016 07:32:12 GMT

plz see the below screen shot

Re: Date Time conversion

Former Member — Thu, 08 Sep 2016 07:38:26 GMT

Try with a space between SSS and XXX.

Re: Date Time conversion

former_member237514 — Thu, 08 Sep 2016 07:46:22 GMT

No luck its not working throwing same error

Re: Date Time conversion

Former Member — Thu, 08 Sep 2016 08:21:15 GMT

Strange.I dont have system to try.

Try with single X..

Re: Date Time conversion

former_member237514 — Thu, 08 Sep 2016 08:25:45 GMT

no it's not working same error only

Re: Date Time conversion

former_member237514 — Thu, 08 Sep 2016 08:44:22 GMT

Hi All,

Any suggestion plz.