lundi 21 mars 2016

Select records from a particular date

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