Filter result by date

Question

Filter result by date

Navigation

#1 by (1 votes)
#2 by (0 votes)

1

My problem is, when I execute the command below:

SELECT Id_produto AS Produto, Quantidade AS quantidade,
genius.vendas.data_venda AS Periodo
FROM genius.itens_venda
LEFT JOIN genius.vendas ON vendas.Id = Id_venda
WHERE 'Id_produto' = 3418;

I have the following as a return:

ButwhenIrunthis:

SELECTId_produtoASProduto,QuantidadeASquantidade,genius.vendas.data_vendaASPeriodoFROMgenius.itens_vendaLEFTJOINgenius.vendasONvendas.Id=Id_vendaWHERE'Id_produto'=3418AND'data_venda'BETWEEN2015-02-23AND2015-02-26;

MySQLdoesnotreturnanyvalue,justtheemptytablewiththenameofthecolumns:

Does anyone have a solution? and I also need to add the amount

mysql

asked by anonymous 25.08.2016 / 01:39

2 answers

0

WHERE 'Id_produto' = 3418 AND ('data_venda' BETWEEN 2015-02-23 AND 2015-02-26);

Would not it solve?

25.08.2016 / 01:50

Pycharm with underline in code How to receive Angular data in a PHP (routed) file

score 1 · Accepted Answer

You can try specifying the date and time:

SELECT Id_produto AS Produto, Quantidade AS quantidade,
genius.vendas.data_venda AS Periodo
FROM genius.itens_venda
LEFT JOIN genius.vendas ON vendas.Id = Id_venda
WHERE 'Id_produto' = 3418 AND 
'data_venda' BETWEEN "2015-02-23 00:00:00" AND "2015-02-26 23:59:59";