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 ?
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
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