Hello,

At least with Oracle 19c version there is a little bug in both versions 2.6 and 2.8:

At line nr 592 of jqgrid_dist.php you have :

$qwery .= “($field >= ‘{$v[‘start’]} 00:00:00′ AND $field <= ‘{$v[‘end’]} 23:59:59′)”;

causes problem depending on the locale used.

It could be fixed with the following syntax:

$qwery .= “($field >= to_date(‘{$v[‘start’]} 00:00:00′,’yyyy-mm-dd hh24:mi:ss’) AND $field <= to_date(‘{$v[‘end’]} 23:59:59′,’yyyy-mm-dd hh24:mi:ss’))”;

Best Regards,