Computing time by field showed no problem, but it used in query parameters appears to be null and void, in what is bosses under this situation?

And to_char (to_date (concat (to_char (NVL (aaa) TAKE_time, aaa. LINK_time), '- dd yyyy - mm'), '23:59'), 'yyyy - mm - dd hh24: mi) + NVL (aaa) THSX, 0) + NVL (aaa) GXSX, 0) + NVL (aaa. PSSX, 0),' - dd yyyy - mm) & gt;
='2020-04-01'
And to_char (to_date (concat (to_char (NVL (aaa) TAKE_time, aaa. LINK_time), '- dd yyyy - mm'), '23:59'), 'yyyy - mm - dd hh24: mi) + NVL (aaa) THSX, 0) + NVL (aaa) GXSX, 0) + NVL (aaa. PSSX, 0),' - dd yyyy - mm) & lt;
='2020-04-30'

This is the time for the calculated parameter of SQL

CodePudding user response:

Computing time by field showed no problem: all the data display, click on the last page, see if it is invalid in ascension

CodePudding user response:

In order to solve, in coat a layer of the query