MQSeries.net :: View topic - Timestamp format problem when migrating to WBIMB V7

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Timestamp format problem when migrating to WBIMB V7

Timestamp format problem when migrating to WBIMB V7

« View previous topic :: View next topic »

Author

Message

[EG]Slayer

Posted: Mon May 09, 2011 7:01 am Post subject: Timestamp format problem when migrating to WBIMB V7

Novice

Joined: 01 Aug 2008
Posts: 16

Hi all,

I'm migrating WBI Message Broker V6 to WBI Message Broker V7 and I've noticed something strange.

I've this line in my flow :
SET OutputRoot.XMLNSC.Msg.Data.CheckDB.TestDate = CURRENT_TIMESTAMP;

The message is sent to a Queue.

If I browse my Queue, I see :

With WBIMB V6 :
<TestDate>2011-05-09 16:33:01.401324</TestDate>

With WBIMB V7 :
<TestDate>2011-05-09T16:33:01.401324</TestDate>

--> Why there is this "T" in the middle of my timestamp?

Is there a solution to have the same format than V6? (without casting the timestamp in a string)

Thanks

Vitor

Posted: Mon May 09, 2011 7:18 am Post subject: Re: Timestamp format problem when migrating to WBIMB V7

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

[EG]Slayer wrote:

Is there a solution to have the same format than V6? (without casting the timestamp in a string)

Do a search in here for 'v7 timestamp'. You're not the first to notice this and it's been discussed a few times.

The Search Facility Is Your Friend.
_________________
Honesty is the best policy.
Insanity is the best defence.

kimbert

Posted: Mon May 09, 2011 11:28 am Post subject:

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

See my reply in this thread : http://www.mqseries.net/phpBB2/viewtopic.php?t=54346&sid=6a074d9441d8409f3d2cb42f7ad3717e

You *can* force XMLNSC to use the same format as it used in v6.0, but I do not recommend that route. Almost all XML applications expect the format that XMLNSC now uses.

[EG]Slayer

Posted: Tue May 10, 2011 5:14 am Post subject:

Novice

Joined: 01 Aug 2008
Posts: 16

ok thanks

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Timestamp format problem when migrating to WBIMB V7

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