MQSeries.net :: View topic - casting timestamp issue

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 » casting timestamp issue

casting timestamp issue

« View previous topic :: View next topic »

Author

Message

WMBSAM

Posted: Thu Mar 14, 2013 6:36 am Post subject: casting timestamp issue

Voyager

Joined: 02 Oct 2009
Posts: 90
Location: Atlanta

trying to convert timestamp format from 2013-02-09 00:00:58.631 to 2013-02 -09T00:00:58.000Z

Here is what code looks like:

SET target = CAST(inputdatetime AS TIMESTAMP FORMAT 'M/d/yy HH:mm');

here target value comes as 2013-02-09 00:00:58.631

SET target.Date = CAST(target as TIMESTAMP FORMAT 'IU');

any thoughts??

mqjeff

Posted: Thu Mar 14, 2013 6:45 am Post subject:

Grand Master

Joined: 25 Jun 2008
Posts: 17447

A broker timestamp has no physical format.

You are attempting to instruct a broker timestamp on what it's physical format is.

You need to instruct broker on the physical format of the data you are creating or serializing the timestamp from and to.

kimbert

Posted: Thu Mar 14, 2013 7:20 am Post subject:

Jedi Council

Joined: 29 Jul 2003
Posts: 5542
Location: Southampton

mqjeff is correct.

You need to cast the input string to a timestamp using format1, then cast the timestamp to a string using format2. That's not what your code is currently doing

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » casting timestamp issue

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