The date and time between the two columns of
How to combine the query statements of a certain time period to another time?
For example,
Column A date column B time
20200521 06:00:00
20200522 06:00:00

How to query 06:00:00 20200521 to 20200522 06:00:00

CodePudding user response:

Column A, B, what data type column is?

Something like this:
Select * from t
Where A column + "+ B column between '20200521 06:00:00' and '20200522 06:00:00'

If you is not a string type, may have to change my,