Author |
Message
|
SphereOfLove |
Posted: Sat May 17, 2014 10:44 am Post subject: Integration Bus9 |
|
|
Apprentice
Joined: 13 May 2014 Posts: 38
|
Hi I can not cast date
SET castTime = CAST(RefOutRecord.Response.ServiceHeader.MessageTime AS DATE CCSID 1208);
where RefOutRecord.Response.ServiceHeader.MessageTime has value like
'2014-05-17T20:36:41+01:00' i want to convert it to DATE to insert into oracle table defined as DATE. |
|
Back to top |
|
 |
fjb_saper |
Posted: Sat May 17, 2014 2:32 pm Post subject: Re: Integration Bus9 |
|
|
 Grand High Poobah
Joined: 18 Nov 2003 Posts: 20763 Location: LI,NY
|
SphereOfLove wrote: |
Hi I can not cast date
SET castTime = CAST(RefOutRecord.Response.ServiceHeader.MessageTime AS DATE CCSID 1208);
where RefOutRecord.Response.ServiceHeader.MessageTime has value like
'2014-05-17T20:36:41+01:00' i want to convert it to DATE to insert into oracle table defined as DATE. |
So why did you not specify a format clause in your cast?  _________________ MQ & Broker admin |
|
Back to top |
|
 |
SphereOfLove |
Posted: Sat May 17, 2014 3:24 pm Post subject: |
|
|
Apprentice
Joined: 13 May 2014 Posts: 38
|
I did try the other way too, but it is still giving me cast exception. |
|
Back to top |
|
 |
fjb_saper |
Posted: Sat May 17, 2014 3:45 pm Post subject: |
|
|
 Grand High Poobah
Joined: 18 Nov 2003 Posts: 20763 Location: LI,NY
|
SphereOfLove wrote: |
I did try the other way too, but it is still giving me cast exception. |
Maybe you did not correctly describe your format?  _________________ MQ & Broker admin |
|
Back to top |
|
 |
jsware |
Posted: Mon May 19, 2014 3:46 am Post subject: |
|
|
 Chevalier
Joined: 17 May 2001 Posts: 455
|
What's the exception you get and what was the format clause in the other attempt? _________________ Regards
John
The pain of low quaility far outlasts the joy of low price. |
|
Back to top |
|
 |
|