Date Range Search in SQL

Basically this:

SELECT DATE_FORMAT( data_venda, '%d-%m-%Y') AS datavenda
  FROM venda
  WHERE data_venda BETWEEN '2016-01-18' AND '2016-02-15'

To use more fields:

SELECT campo1, campo2, DATE_FORMAT( data_venda, '%d-%m-%Y') AS datavenda, campo3
   ...etc...

AS datavenda is the name you want to use as a return for the search. Preferably, use a name that is not repeated as a table field to avoid confusion.

You can even use the asterisk, but the field will be unformatted in the asterisk, and formatted at the end:

SELECT *, DATE_FORMAT( data_venda, '%d-%m-%Y') AS datavenda
  FROM venda
  WHERE data_venda BETWEEN '2016-01-18' AND '2016-02-15'

But I do not recommend it. It is always good to specify only the fields you are going to use.

Just in your select you specify and format the output with the desired pattern example:

SELECT 
    id_venda,
    DATE_FORMAT(data_venda,'%d-%m-%Y'),
    valor_venda,
    id_cliente
FROM venda

The downside is that you will need to specify the fields however I do not know how to get to your result.

NOTE: I did not put your where clause because I did not know which one you intend to use, but they do not need to be modified.

You are formatting the date erroneously in the WHERE condition. Just remove the formatting.

To receive the formatted date, do this in the SELECT snippet. Correction example:

select 
id_venda,
DATE_FORMAT(data_venda, '%d-%m-%Y') as data_venda,
valor_venda,
id_cliente
from venda where data_venda = '2016-01-18'

The same thing in the second query. Fix following the same logic as the example above.