Our Training Programs

All contents are copyright of their authors.

no data sqlite select with condition on datetime

no data sqlite select with condition on datetime

Abhilash J A

9yAsked Nov 16, 2016, 4:47 AM1.4kSQL

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

The SQLite Tble_Login looking like this,

After excute this query, no data? How can I get data?

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Nitin Sontakke9y ago
Accepted 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 Gupta9y ago
Please rectify your query, you had mentioned LogInTime and output is of LogOutTime column, all else are correct