Re: [sqlite] Bug Report: DateTime incorrect for Windows

2010-02-26 Thread 4eanlss
4611627*(5^9)*(3^3) = 0x0DD2E611DD10D Divide by remaining factors 2*(5^9)*(3^3) = 105468750 */ ft64.u.LowPart = ft.dwLowDateTime; ft64.u.HighPart= ft.dwHighDateTime; *prNow = ((ft64.QuadPart>>13) + 0x0DD2E611DD10DL) / 105468750.0L; return 0; } 4

Re: [sqlite] Bug Report: DateTime incorrect for Windows

2010-02-26 Thread 4eanlss
L; or this: (sqlite3_int64)1<<32; // but only with typecast 4eanlss ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Bug Report: DateTime incorrect for Windows

2010-02-25 Thread 4eanlss
00 + (sqlite3_int64)20 + (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

Re: [sqlite] Bug Report: DateTime incorrect for Windows

2010-02-23 Thread 4eanlss
Shane Harrelson writes: > > I was unable to duplicate your error with the CLI and 3.6.22 (compiled with > cygwin\gcc or msvc): Ok, so Borland not supported and windows API not followed. Just as I expected from open source software.

[sqlite] Bug Report: DateTime incorrect for Windows

2010-02-05 Thread 4eanlss
Hello, I'm compiling the 3.6.21 amalgamation with Borland command-line compiler version 5.2 for Windows XP. My compilation command is bcc32.exe -5 -H- -O2 -RT- -a8 -x- maintest.c sqlite3.c where maintest.c is similar to the http://www.sqlite.org/quickstart.html sample C code. The 3 SQL