T
T
tsul2015-02-17 05:12:26
.NET
tsul, 2015-02-17 05:12:26

Is there a SQLite database manager with custom DATETIME view capability?

In my databases I use DateTime.Ticks to store time (via System.Data.SQLite).
Those. field type is DATETIME, and

ConnectionString = "Data Source={0};DateTimeFormat=Ticks;DateTimeKind=Utc"

Quite conveniently, System.Data.SQLite itself takes care of converting DateTime to Ticks when writing to a table, and vice versa. Plus, it's very fast (for logging on my bike).
I want to be able to view tables, make queries, and see the time in a human-readable format as a result. Do you know a manager (or at least a viewer) that can represent time in the DateTime.Ticks format (well, or at least Julian day) in human form?
I haven't seen any SQLite database manager that allows you to represent dates from such fields in human form. At most, some managers believe that if the field type is DATETIME, then UnixTime is written there.
The accuracy of UnixTime is small for me (you need up to microseconds), I don’t want to use Julian Day (overhead increases, and I doubt that it will save). ISO8601 and other strings will not be used because of overhead conversions and queries.
Views are not an option: I have a lot of such fields, each table has its own view - it is inconvenient to maintain later.
There would be calculated fields, but it seems like they are not in sqlite, if I'm not mistaken (there weren't, at least), and fencing triggers is also not an option, not why.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question