| Author |
Message
|
| prabha |
 Posted: Mon Jan 07, 2008 9:04 pm Post subject: Time zone Information |
 |
|
Newbie
Joined: 13 Jul 2006
Posts: 9
Location: india-chennai
|
Hi
Does MB retain the time zone information like+05:30 while pasring.
I have a input data like 2001-12-31T16:30:00.000+02:00 but after parsing it is changed to 2001-12-31T16:30:00.000, the zone information "+02:00" is truncated.
The datetime format set in the messageset is yyyy-MM-dd'T'HH:mm:ss.SSSZZZU.
Can anyone help me out in this issue. |
|
| Back to top |
|
 |
| kimbert |
| Posted: Tue Jan 08, 2008 1:21 am Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| The MRM parser does preserve time zone info. Which version of WMB are you using? |
|
| Back to top |
|
|
| prabha |
| Posted: Tue Jan 08, 2008 1:28 am Post subject: |
|
|
Newbie
Joined: 13 Jul 2006
Posts: 9
Location: india-chennai
|
|
| Back to top |
|
|
| kimbert |
| Posted: Tue Jan 08, 2008 1:37 pm Post subject: |
|
|
Jedi Council
Joined: 29 Jul 2003
Posts: 5542
Location: Southampton
|
| Quote: |
| after parsing it is changed to 2001-12-31T16:30:00.000 |
Q1 : How are you determining this? By looking at the tree, or by looking at the output message?
Q2 : What is your message flow trying to do? |
|
| Back to top |
|
|
| VivekMeshram |
| Posted: Tue Jan 08, 2008 5:24 pm Post subject: |
|
|
Voyager
Joined: 25 Mar 2002
Posts: 83
|
Prabha,
Why don’t you define type as a sting for this date field to parse time zone requirement and later in message flow covert the date format as desire. |
|
| Back to top |
|
|
| prabha |
| Posted: Tue Jan 08, 2008 8:17 pm Post subject: |
|
|
Newbie
Joined: 13 Jul 2006
Posts: 9
Location: india-chennai
|
Kimbert,
A1:By Looking at the tree
A1:I extract the date and assign it to a date field ,Take the time portion ans assign it to a time field |
|
| Back to top |
|
|
| prabha |
| Posted: Tue Jan 08, 2008 9:36 pm Post subject: |
|
|
Newbie
Joined: 13 Jul 2006
Posts: 9
Location: india-chennai
|
i tried out the option of having the datatype of the field as string,it works.
I have one more thougth of placing the data pattern restriction on that field.The data pattern which i am giving should conform to both these data
2001-12-31T16:30:00.000Z and 2001-12-31T16:30:00.000+02:00 .
Can anyone help me out? |
|
| Back to top |
|
|
|
|
