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: Problem CASTing timestamp string to ESQL TIMESTAMP variable
gcauthon

Replies: 1
Views: 4279
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Fri Jun 29, 2012 7:45 am   Subject: Problem CASTing timestamp string to ESQL TIMESTAMP variable
Never mind... I just noticed that the minutes should be "mm"... not "MM".
  Topic: Problem CASTing timestamp string to ESQL TIMESTAMP variable
gcauthon

Replies: 1
Views: 4279
 PostForum: WebSphere Message Broker (ACE) Support   Posted: Fri Jun 29, 2012 7:38 am   Subject: Problem CASTing timestamp string to ESQL TIMESTAMP variable
I'm trying to read a timestamp value that is stored as so: 201205230858220 and cast it to a TIMESTAMP variable in ESQL, but I keep getting an invalid date error.

The ESQL looks like this:

DECLAR ...
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.