According to the PL/SQL table in a certain time field query data over a long period, SQL is as follows: SELECT * FROM tb1 t WHERE t.a _date & gt;=to_date (' 2021-01-01 ', '- DD YYYY - MM) AND t.a _date & lt; To_date (' 2021-02-28 ', '- DD YYYY - MM), now I want to a dynamic query any two months of data, the SQL what to write? In the,

CodePudding user response:

What is the mode of given point in time is two months