We notice a mismatch in App and DB server times when the following is done.
A sample screenshot of how the comparison is made is provided below.
Version: 15.9.3
<gel:script xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:core="jelly:core"
xmlns:gel="jelly:com.niku.union.gel.GELTagLibrary"
xmlns:soap="jelly:com.niku.union.gel.SOAPTagLibrary"
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:sql="jelly:sql"
xmlns:xog="http://www.niku.com/xog"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<gel:setDataSource dbId="niku"/>
<sql:query var = "result">
<![CDATA[
select now() time_test
]]>
</sql:query>
<gel:log> ${result.rows[0].time_test} </gel:log>
</gel:script>