In my table I store the data like 2015-11-24 14:53
.
When I try to select the records from the date 2015-11-24
SELECT * FROM TRANSACTIONS where id='22'
and date >= date('2015-11-24 00:00')
and date <= date('2015-11-24 23:59')
I don't get anything.. (there are records with that date)
Aucun commentaire:
Enregistrer un commentaire