Abhilash J A

Abhilash J A

  • NA
  • 2.4k
  • 583.2k

no data sqlite select with condition on datetime

Nov 16 2016 4:47 AM
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)