ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » Search

 Search found 2 matches
Author Message
  Topic: Esql Time datatype - cast problem.
paulballard

Replies: 5
Views: 7264
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Tue May 29, 2007 12:41 am   Subject: Esql Time datatype - cast problem.
Hi,

Thanks for your replies. My original post was not 100% accurate.

The problem is that we are receiving the data from a back end system in the format hhmm and wish to convert this into the for ...
  Topic: Esql Time datatype - cast problem.
paulballard

Replies: 5
Views: 7264
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Mon May 21, 2007 4:52 am   Subject: Esql Time datatype - cast problem.
Hello,

I am experiencing a problem when casting to a time datatype. The following shows my esql code:

set out.latestExpectedTimeOfArrival = cast(in.expectedTime as time format 'HH:mm:ss');

Th ...
Page 1 of 1

Jump to:  
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.