On Fri, Feb 26, 2010 at 1:49 AM, 4eanlss <4ean...@engineer.com> wrote:
>
> Shane,
>
> I apologize for my quick snap response.
> I have debugged the code and have identified what is happening.
> The calculation in my environment results in 0 (zero) for this:
> static const sqlite3_int64 max32BitValue =
> (sqlite3_int64)2000000000 + (sqlite3_int64)2000000000 +
> (sqlite3_int64)294967296;
>
> Which breaks all of the following datetime calculations.
> When compiled with the type sqlite3_uint64 then it works correctly.
>
> I am working on a much simpler winCurrentTime solution but I'm stilling
> creating all test cases to verify the algorithm before posting.
>
> 4eanlss
>
>
I'd be worried that other 64 bit calculations are going wrong as well.
Can you verify what type sqlite3_int64 is being set to in your environment?
Also can you try the following (note the L suffix on the constants):
static const sqlite3_int64 max32BitValue =
(sqlite3_int64)2000000000L + (sqlite3_int64)2000000000L +
(sqlite3_int64)294967296L;
-Shane
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
