2
Reply

no data sqlite select with condition on datetime

Ask a question
I have select query for SQLite Database. There is a LogInTime field that datetime datatype.
Here is AccessDate variable containing date "11/16/2016" like format
 
  1. string sql = "SELECT * FROM Tble_Login where LogInTime = '" + AccessDate + "'";  
 
 
The SQLite Tble_Login looking like this,
 
 
After excute this query, no data? How can I get data?
 
 

Answers (2)