Hi everyone,

I have to save and retrieve (by BETWEEN) dates from a SQlite database.
Which is the best way to do it? (both operations)

I tried with saving it as a QString in the db, but then it seems that the db is not able to operate the record as a date... date(myrecord) shows an empty string...while without date() shows the string but can't be used for comparison.
These are just a series of situations, but anyway the question is the first one: how to save date records in a sqlite db and retrieve them with between comparison?

PS: db record IS a DATE format and I can't use QSqlQuery::bindValue() for some reasons.

Thank you in advance!