| 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 |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Sat Jun 04, 2016 3:41 am Post subject: Re: Time casting issue |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20763
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 |
|
| Back to top |
|
|
| 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. |
|
| Back to top |
|
|
| 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>); |
|
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sun Jun 05, 2016 1:09 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20763
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 |
|
| Back to top |
|
|
|
|
