MQSeries.net :: View topic - Need to check whether incoming date time object is 6 months

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Need to check whether incoming date time object is 6 months

Need to check whether incoming date time object is 6 months

« View previous topic :: View next topic »

Author

Message

muthu121521

Posted: Thu Feb 16, 2017 7:47 am Post subject: Need to check whether incoming date time object is 6 months

Apprentice

Joined: 31 Aug 2015
Posts: 36

Hi ,
I have a requirement to check whether an incoming object is 6 month old or not
I am using interval function.
I am getting the input as GMT date time stamp format
I am using
XX Interval;
xx = (CURRENT_GMTTIME - Incomingdatetimestamp)MONTH
I am getting Casting error, PFB the error
Cannot evaluate '%1 %2 %3' because the types are incompatible

Can any one let me know , how to achieve this in esql ?

adubya

Posted: Thu Feb 16, 2017 8:30 am Post subject:

Partisan

Joined: 25 Aug 2011
Posts: 377
Location: GU12, UK

What ESQL type is Incomingdatetimestamp ? By it's name it seems that it has a date component. This would be incompatible with CURRENT_GMTTIME as an implicit cast I believe.
_________________
Independent Middleware Consultant
andy@knownentity.com

Vitor

Posted: Thu Feb 16, 2017 9:47 am Post subject:

Grand High Poobah

Joined: 11 Nov 2005
Posts: 26093
Location: Texas, USA

adubya wrote:

By it's name it seems that it has a date component. This would be incompatible with CURRENT_GMTTIME as an implicit cast I believe.

Don't you mean CURRENT_GMTTIMESTAMP?
_________________
Honesty is the best policy.
Insanity is the best defence.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Need to check whether incoming date time object is 6 months

Jump to:

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

Protected by Anti-Spam ACP