Re: [sqlite] Date (from REAL) with Negative Year

3 December, 2016 08:37 > To: SQLite mailing list > Subject: Re: [sqlite] Date (from REAL) with Negative Year > > rather unintuitively excel uses the OLE automation timestamp that > records the number of days since 1899/12/30 > > http://sandersonforensics.com/forum/conten

Re: [sqlite] Date (from REAL) with Negative Year

rather unintuitively excel uses the OLE automation timestamp that records the number of days since 1899/12/30 http://sandersonforensics.com/forum/content.php?131-A-brief-history-of-time-stamps https://msdn.microsoft.com/en-us/library/system.datetime.tooadate(v=vs.110).aspx now no need for the

Re: [sqlite] Date (from REAL) with Negative Year

> But that does not seems to be the whole story, since if I do: > > SELECT datetime(42713.1916667+julianday('1900-01-01')); > > I get 2016-12-11 04:36:00 instead of what you were expecting > 2016-12-09 05:15. Something is a little off. I suspect that there I think he is expecting

Re: [sqlite] Date (from REAL) with Negative Year

On 12/12/16, Lipson, Ed wrote: > Python 32bit, Windows 7 64bit > How do I turn a real into a date? That depends on how the real number represents a date. SQLite supports two very popular encodings: Julian Day Number (https://en.wikipedia.org/wiki/Julian_day) and Unix