ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Handling timezone in graphical mapping

Post new topic  Reply to topic
 Handling timezone in graphical mapping « View previous topic :: View next topic » 
Author Message
ruimadaleno
PostPosted: Tue Jun 02, 2015 6:46 am    Post subject: Handling timezone in graphical mapping Reply with quote

Master

Joined: 08 May 2014
Posts: 274
Hi all,

we are running a message flow that uses a graphical data mapping to convert xml formats. the problem is we are "loosing" timezone information in mappging

xml in
-------
<data>
<dataSinistro>2015-05-25</dataSinistro>
<horaSinistro>01:00:00+01:00 </horaSinistro>
</data>

xml out
---------
<dataOut>
<Sinistro>2015-05-25T01:00:00</Sinistro>
</dataOut>

transformation diagram

dataSinistro -------------->| fn:datetime -----> Sinistro
horaSinistro ------------->|


my environment: WMB 8.0.0.4 running on windows 2008 r2 server
_________________
Best regards

Rui Madaleno
Back to top
View user's profile Send private message
mqjeff
PostPosted: Tue Jun 02, 2015 6:55 am    Post subject: Reply with quote

Grand Master

Joined: 25 Jun 2008
Posts: 17447
Why are you casting it to a date time?

Isn't it already? If it's a string, why are you casting it?

What does the XML standard say about the format of datetime fields?
Back to top
View user's profile Send private message
ruimadaleno
PostPosted: Tue Jun 02, 2015 8:23 am    Post subject: Reply with quote

Master

Joined: 08 May 2014
Posts: 274
Hi mqJeff

dataSinistro type is xs:date
horaSinistro type is xs:time

Sinistro type is xs:datetime

The result (Sinistro) must be the concat of both date (dataSinistro) and time (horaSinistro). fn:dateTime should be able to concat date and time and as a result provide a datetime (with time zone)

http://www.w3.org/TR/xquery-operators/#func-dateTime
_________________
Best regards

Rui Madaleno
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Handling timezone in graphical mapping
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.