Query between date range?

Navigation
3

Table Ciclos :

I have the date 2018-07-05

How can I put a query between the ranges of CiDtIni and CiDtFim according to the date above?

    
asked by anonymous 12.07.2018 / 18:50

1 answer

3

I had informed a query in the comments tab that I believe is what you need. Just use BETWEEN to work with range dates. 

SELECT *
FROM Ciclos
WHERE dataInformada BETWEEN CiDtIni AND CiDtFim
    
12.07.2018 / 20:02
How do I delete a specific object on the HTML5 canvas? TDD with micro services