this is a part of my db and i want to obtain a query like this:
select * from tb_store where data_in between '01-01-2014 00:00:00' AND '15-01-2015 23:59:59'
but the problem is that if the value of the second data are 15-01-2015 23:59:59 (present in the table only the day) the result are ok, otherwise if the data are 01-01-2015 23:59:59 the result are empty. where is the problem?
nome data_in
cioccolato 14-01-2015 13:38:36
mascarpone 14-01-2015 13:38:36
crema 14-01-2015 13:38:36
pistacchio 14-01-2015 13:38:36
nocciola 14-03-2015 13:38:36
fior di panna 14-03-2015 13:38:36
stracciatella 14-02-2015 13:38:36
zucca 14-02-2015 13:38:36
arancia 15-02-2015 13:38:36
Aucun commentaire:
Enregistrer un commentaire