| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Character to date in Esql Casting ? |
« View previous topic :: View next topic » |
| Author |
Message
|
| cvanmook |
 Posted: Tue Oct 05, 2004 12:52 pm Post subject: Character to date in Esql Casting ? |
 |
|
Novice
Joined: 16 Jan 2004
Posts: 23
|
Hello,
We've a problem with casting a string to an date. We'll get from our SAP system an IDOC with a string field filled with "yyyymmdd" . We want to fill the field to our output xml in a field of type date with format 'yyyy-mm-dd'
Thanx,
Christan |
|
| Back to top |
|
 |
| RocknRambo |
| Posted: Tue Oct 05, 2004 2:11 pm Post subject: |
|
|
Partisan
Joined: 24 Sep 2003
Posts: 355
|
how r u trying that...
I mean..what error r u getting...
bydefault, every element in xml is char, to just change the format, u dont need to CAST into DATE datatype.
try to substring and concatenate, u shud get it. |
|
| Back to top |
|
|
| jefflowrey |
| Posted: Tue Oct 05, 2004 4:28 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
Yeah, you could use the MRM to model your XML, and then define this element as containing a date, and then set the date format to output the way you want...
Or you could just use substring and concatenate in your ESQL...
Which ever seems easier to you is probably the best choice...
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| cvanmook |
| Posted: Wed Oct 06, 2004 1:30 pm Post subject: |
|
|
Novice
Joined: 16 Jan 2004
Posts: 23
|
We've already managed to convert this with the substring but I thought it should be done a lot easier ..... like in normal SQL statements ... but this works..
thanx. |
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
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
|
|
|
|
