Hello
Is it possible to ignore the timezone of the server when calculating the difference between 2 timestamps using TIMESTAMPDIFF(interval, startTime, endTime) ?
Thanks
|
You may want to use org.teiid.calendarTimestampDiff=false - see System Properties · Teiid Documentation
But generally sources compute the difference of timestamps based upon calendar fields rather than the absolute UTC difference.