CODEWITHSUNDEEP
android
user533787
user533787

Reputation: 709

how to select date in sql query

I added a lot of values in SQLite. How do I write query for searching dates earlier than today ?

Upvotes: 0

Views: 1291

Answers (1)

richaux
richaux

Reputation: 2672

Further details are available in the sqlite documentation ... but the following should be the sort of thing you're after.

SELECT columnA, columnB
FROM tableX
WHERE dateColumn < date('now')

If this doesn't help, you should look to post more details of your tables, related code, etc..

Upvotes: 1

Related Questions