Makes sense,
Somehow I had in my head that int64 would still only get you to the year 5000 
or so.
I guess the question is if it should fail like that in this case. Capping it at 
DateTime.MaxValue does not seem ideal either.

Jann

-----Original Message-----
From: sqlite-users-bounces at mailinglists.sqlite.org 
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Joe 
Mistachkin
Sent: 28 April 2016 19:54
To: 'SQLite mailing list' <sqlite-users at mailinglists.sqlite.org>
Subject: Re: [sqlite] [System.Data.SQLite] int overflow in date handling when 
unixepoch is used


Jann Roder wrote:
>
> I just tested the new version that should have the fix for this and
> now I get an ArgumentOutOfRangeException exception when I actually
> have a value of Int64.MaxValue in a date column. Stack trace:
>

I am able to recreate the exception here.  The value of Int64.MaxValue is 
9223372036854775807.  The UnixEpoch values are measured in seconds from the 
epoch 1970-01-01 00:00:00Z.  Adding 9223372036854775807 seconds to the 
UnixEpoch would result in a DateTime far beyond the allowed maximum value for 
DateTime in the .NET Framework, which is 9999-12-31 23:59:59.9999999.

--
Joe Mistachkin

_______________________________________________
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



Winton Capital Management Limited (?Winton?) is a limited company registered in 
England and Wales with its registered offices at 16 Old Bailey, London, EC4M 
7EG (Registered Company No. 3311531). Winton is authorised and regulated by the 
Financial Conduct Authority in the United Kingdom, registered as an investment 
adviser with the US Securities and Exchange Commission, registered with the US 
Commodity Futures Trading Commission and a member of the National Futures 
Association in the United States.

This communication, including any attachments, is confidential and may be 
privileged. This email is for use by the intended recipient only. If you 
receive it in error, please notify the sender and delete it. You should not 
copy or disclose all or any part of this email.

This email does not constitute an offer or solicitation and nothing contained 
in this email constitutes, and should not be construed as, investment advice. 
Prospective investors should request offering materials and consult their own 
advisers with respect to investment decisions and inform themselves as to 
applicable legal requirements, exchange control regulations and taxes in the 
countries of their citizenship, residence or domicile. Past performance is not 
indicative of future results.

Winton takes reasonable steps to ensure the accuracy and integrity of its 
communications, including emails. However Winton accepts no liability for any 
materials transmitted. Emails are not secure and cannot be guaranteed to be 
error free. Winton handles personal information in accordance with its privacy 
notice.<https://www.wintoncapital.com/en/regulatory-disclosures#privacypolicy>

Reply via email to