DateTime property in model gets created as a bigint column in DB


DateTime? property in my model gets created as bigint column in the DB.

When I run following sql using me.Execute(), it deletes all rows.

WHERE ModifiedAt < ‘2016-09-01T00:00:00’

It used to work fine with older version of SQLCipher, in which it created a DateTime column in DB.

Has something changed @developernotes?


Hello @hemantksh

Are you using the PCL-based SQLCipher library? If so, you can pass false as the third parameter to the SQLiteConnection constructor telling it not to use ticks by default. Would you give that a try when you have the opportunity to see if that matches the behavior you are looking for when creating the database?


Thank you @developernotes!
It worked like a charm.