On Thu, Sep 24, 2015 at 5:17 PM, Bohms, H.M. (Michel) <michel.bo...@tno.nl> wrote: > > But the result gives values of interval 2 hours shifted….any tip very > welcome, >
I guess that looks like a bug. I guess the timezone is taken into account twice (casting and comparision) . Please Michel, report the issue to Jira, including test data and queries to help up dealing with it. -- Sergio Fernández Partner Technology Manager Redlink GmbH m: +43 6602747925 e: sergio.fernan...@redlink.co w: http://redlink.co