no data sqlite select with condition on datetime

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 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?

Nitin Sontakke · Answer

As I keep stating every time I see this please use globally neutral date format such as '2016-11-16'. Do not use '11/16/2016' Please remove the misconception that it is stored as 11/16/2016 in the database. It is not. It is stored as integer or bigint. It is only shown to you in that format just because your computer's regional settings are like that. Change the computer's regional settings and you will see that it is changed as well.

Amit Gupta · Answer

Please rectify your query you had mentioned LogInTime and output is of LogOutTime column all else are correct