title: SQLite: How to convert a bigint field to date or timestamp?
body: <p>I've received a SQLite file with .db extension.
  Opening it, I have a column with serial numbers: i.e. 1600414704594 (that should correspond to 2020-10-09 and whatsover time)
  The db comes from outside and I don't know how that date field has been built.
  Could you suggest me a query to get a valid date/time from that db column ?
  I've tried reading <a href="https://stackoverflow.com/questions/1342448/convert-sqlite-bigint-to-date">this post</a> but none of the given solution returned me a valid (and actual) date, please help me.</p>