| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Problem in getting Timezone in output Date format |
« View previous topic :: View next topic » |
| Author |
Message
|
| sguruprasanna |
 Posted: Fri May 06, 2005 1:47 pm Post subject: Problem in getting Timezone in output Date format |
 |
|
Apprentice
Joined: 29 Jul 2002
Posts: 37
|
Hi,
I am trying to write an XML message configured in MRM. One of the field 'MdfyDate' is of type DATETIME. In the messageset, the properties for this field in the XML tab is set as:
Member Format: yyyy-MM-DDZZZ
Element Properties:Format: yyyy-MM-DDZZZ
From the ESQL code, I am setting the value for this field as:
2005-05-07-04:00
But in the output, this field is appearing as:
2005-05-07+00:00
ESQL code is:
| Code: |
DECLARE C INTEGER;
SET C = CARDINALITY(InputRoot.*[]);
DECLARE I INTEGER;
SET I = 1;
WHILE I < C DO
SET OutputRoot.*[I] = InputRoot.*[I];
SET I=I+1;
END WHILE;
-- Enter SQL below this line. SQL above this line might be regenerated, causing any modifications to be lost.
Set OutputRoot.Properties.MessageFormat = 'XML';
Set OutputRoot.Properties.MessageDomain = 'MRM';
Set OutputRoot.Properties.MessageType = 'DateTest';
Set OutputRoot.Properties.MessageSet = 'DQDE7RK0CQ001';
Set "OutputRoot"."MRM"."MdfyDate" = CAST(InputBody."Test"."Date" AS CHAR);
|
In the input for "Test"."Date" , I am passing : 2005-05-07-04:00
Why is the timezone value getting changed to +00:00? Please help.
PS: The message set property - Default Time Zone ID is set as "Use Broker Locale"
regards
Guru |
|
| Back to top |
|
 |
| sguruprasanna |
| Posted: Mon May 09, 2005 5:47 am Post subject: |
|
|
Apprentice
Joined: 29 Jul 2002
Posts: 37
|
Hi guys,
I am still stuck.... Can you help me here? Has anybody faced this problem before?
regards
Guru |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon May 09, 2005 12:27 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
Possibly because if you are at 4:00 AM GMT
it is 0:00 or 12:00 AM EDT ?? |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
