I am trying to get date from date base in the range of two dates via using below query
SELECT * FROM TransactionLog WHERE TransactionDate > '2016-04-04' it is fetching data correctly but when I am including time along with date then it is not fetching data
SELECT * FROM TransactionLog WHERE TransactionDate > '2016-04-04 11:17:07' this is the query i am using for date and time. Is there a different way when time is included?
Aucun commentaire:
Enregistrer un commentaire