Author |
Message |
Topic: Time casting issue |
Skumarmly
Replies: 4 Views: 4739
|
Forum: WebSphere Message Broker (ACE) Support Posted: Sat Jun 04, 2016 8:52 am Subject: Time casting issue |
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. |
Topic: Time casting issue |
Skumarmly
Replies: 4 Views: 4739
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 03, 2016 8:34 pm Subject: Time casting issue |
Does time zone matters when casting the Time to character |
Topic: timestamp formatting |
Skumarmly
Replies: 12 Views: 8144
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jun 15, 2015 11:36 pm Subject: timestamp formatting |
Thanks Santosh ,this code served my purpose and thanks everyone  |
Topic: timestamp formatting |
Skumarmly
Replies: 12 Views: 8144
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jun 15, 2015 10:05 am Subject: timestamp formatting |
DECLARE respTime CHARACTER CAST(InputRoot.HTTPResponseHeader.Date AS CHARACTER FORMAT 'yyyy-MM-dd HH:mm:ss');
but its not formatting
respTime:CHARACTER:Mon, 15 Jun 2015 18:04:04 GMT
am getti ... |
Topic: timestamp formatting |
Skumarmly
Replies: 12 Views: 8144
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jun 15, 2015 7:36 am Subject: timestamp formatting |
under InputRoot.HTTPResponseHeader.Date I have " Mon, 15 Jun 2015 13:32:17 GMT "
so you mean to say I cant cast this character to timestamp??? |
Topic: timestamp formatting |
Skumarmly
Replies: 12 Views: 8144
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jun 15, 2015 7:30 am Subject: timestamp formatting |
I'm planning to add some Minutes to that time stamp to perform transactions till that time ends.
once the current time Reaches that time transactions should stop or again request for a new expiry t ... |
Topic: timestamp formatting |
Skumarmly
Replies: 12 Views: 8144
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jun 15, 2015 7:26 am Subject: timestamp formatting |
DECLARE respTime CHARACTER InputRoot.HTTPResponseHeader.Date;
DECLARE RespTime TIMESTAMP CAST(respTime AS TIMESTAMP FORMAT 'EEE,DD-MMM-YYYY HH:MM:SS'); |
Topic: timestamp formatting |
Skumarmly
Replies: 12 Views: 8144
|
Forum: WebSphere Message Broker (ACE) Support Posted: Mon Jun 15, 2015 5:35 am Subject: timestamp formatting |
In response I could see date field with value Mon, 15 Jun 2015 13:32:17 GMT(character) I need that in Timestamp format yyyy-mm-dd hh:mm:ss
I used cast function but its throwing error
suggest m ... |
Topic: Parser Error- httpRequest node |
Skumarmly
Replies: 4 Views: 7364
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 12, 2015 3:38 am Subject: Parser Error- httpRequest node |
I found where the problem was , I was using HttpInput node to get the input from external system which was adding the input header ,now I deleted the input header and able to get response   |
Topic: Parser Error- httpRequest node |
Skumarmly
Replies: 4 Views: 7364
|
Forum: WebSphere Message Broker (ACE) Support Posted: Fri Jun 12, 2015 2:39 am Subject: Parser Error- httpRequest node |
my opinion abt response type is based on soap UI,I could see JSON as well as XML in two different tabs when I hit the same URL
if I set Message domain property in Httprequest node
as XMLNSC am ge ... |
Topic: Parser Error- httpRequest node |
Skumarmly
Replies: 4 Views: 7364
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 11, 2015 9:31 am Subject: Parser Error- httpRequest node |
Even after the backend successful call, am getting parser error
i am able to parse the resonse only through BLOB domain and all other domains are showing error, i am suppose to get response either i ... |
Topic: Oauth in IIB |
Skumarmly
Replies: 2 Views: 3744
|
Forum: WebSphere Message Broker (ACE) Support Posted: Thu Jun 11, 2015 9:17 am Subject: Oauth in IIB |
thanks for the Reply, we changed our design from User level authentication to Application level ,where we will be exchanging request token with application token directly |
Topic: Oauth in IIB |
Skumarmly
Replies: 2 Views: 3744
|
Forum: WebSphere Message Broker (ACE) Support Posted: Tue Jun 09, 2015 9:06 am Subject: Oauth in IIB |
for User level Authorization we need to follow the below steps
1. The consumer requests a request token (usually by passing an application key and application secret)
2. The user is then redirecte ... |