MQSeries.net :: View topic - Time casting 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 » Time casting issue

Time casting issue

« View previous topic :: View next topic »

Author

Message

Skumarmly

Posted: Fri Jun 03, 2016 8:34 pm Post subject: Time casting issue

Novice

Joined: 09 Sep 2014
Posts: 13

Does time zone matters when casting the Time to character

fjb_saper

Posted: Sat Jun 04, 2016 3:41 am Post subject: Re: Time casting issue

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

Skumarmly wrote:

Does time zone matters when casting the Time to character

Is the pope catholic?
I guess that was really a rhetorical question. So what is your problem? Can you describe it in detail?

_________________
MQ & Broker admin

Skumarmly

Posted: Sat Jun 04, 2016 8:52 am Post subject:

Novice

Joined: 09 Sep 2014
Posts: 13

I am trying to cast a date coming from ERP and while casting it to character if the date is 06/07/2016 (UTC) am getting it as 06/08/2015.

timber

Posted: Sat Jun 04, 2016 1:35 pm Post subject:

Grand Master

Joined: 25 Aug 2015
Posts: 1292

Before you do anything else, please quote the exact version of the message broker/IIB runtime that you are using.

Quote:

I am trying to cast a date coming from ERP and while casting it to character if the date is 06/07/2016 (UTC) am getting it as 06/08/2015

Please post a snippet of ESQL that demonstrates exactly this behaviour. e.g.

Code:

DECLARE myDate DATE '2016-06-07'
DECLARE myDateAsString CHARACTER CAST( <put your code here>);

fjb_saper

Posted: Sun Jun 05, 2016 1:09 pm Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

Skumarmly wrote:

I am trying to cast a date coming from ERP and while casting it to character if the date is 06/07/2016 (UTC) am getting it as 06/08/2015.

This looks like only half the story. Depending on time zone 06/07/2016 UTC and 06/08/2016 are the same instant.
I expect here that your 06/08/2015 is a typo and you really meant to say 2016...

_________________
MQ & Broker admin

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Time casting 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