4
I have the following situation, where when trying to query a date by another date using BETWEEN, the specified deadline does not return, only "the previous day".
Is there an outline to address this issue?
Follow the dates recorded in the database and the generated Select:
2016-04-12 16:07:03
2016-04-12 16:33:08
2016-04-14 10:47:33
2016-04-14 11:21:14
SELECT * FROM sales.logger where data BETWEEN "2016-04-12" AND "2016-04-14" ORDER BY data;
Return:
2016-04-12 16:07:03
2016-04-12 16:33:08
Already tried, Where data >= "2016-04-12" and data <= "2016-04-14"
– Marcelo Diniz
Have you tried single quote?
– Ivan Ferrer