Btukfyl

I am writing a query in OrmLite like:

                var items = db.Select<CustomTable>(query => query

                    .Where(record => record.UpdateTimestamp > lastUpdateTime)

                    .OrderBy(status => status.UpdateTimestamp)

                    .Limit(limit));

                return items;

This expression record.UpdateTimestamp > lastUpdateTime in the above query is returning true but the values of both of them are exactly the same in the database. Also on debugging the program, I find they store the exact same value which is: 2018-11-19 11:35:05.24345.

On further debugging, I found that the above query is working fine for timestamp which has the precision of time up to the 3rd decimal place. Eg:

Comparing 2018-11-19 11:35:05.123 and 2018-11-19 11:35:05.123 with > operator like in the above query returns false, but when I do increase the precision up to the 4th decimal place, then it starts failing.

Also, The UpdateTimestamp in CustomTable and lastUpdateTime both are a DateTime object only.

What could be the proper solution for this?

UPDATE
I am getting the value of lastUpdateTime from the db, with the query like:

db.Select<SomeTable>(query => query.Where(row => "SomeKey" == key)).FirstOrDefault();