Re: [sqlite] problem with date/time

2007-07-26 Thread Trevor Talbot
On 7/26/07, JJ <[EMAIL PROTECTED]> wrote: Hi, I've solved the problem at last. One thing I didn't know that creating DirectX device will lower float point precision, it is written in their documentation... So creating DX app and running float calculations is no, no... :) Ah, interesting. T

Re: [sqlite] problem with date/time

2007-07-26 Thread JJ
Hi, I've solved the problem at last. One thing I didn't know that creating DirectX device will lower float point precision, it is written in their documentation... So creating DX app and running float calculations is no, no... :) On the other hand one might use D3DCREATE_FPU_PRESERVE flag, to av

Re: [sqlite] problem with date/time

2007-07-26 Thread JJ
First, I have to say that it is likely another "memory leak" (mine) type unobvious bug, it happens only once specific place in my program calls SQLite with date/time function. I can't imagine how memory leak would cause arithmetics to go bizzare, only perhaps something with floating point flags

Re[2]: [sqlite] problem with date/time

2007-07-24 Thread Teg
Hello Trevor, Tuesday, July 24, 2007, 4:49:28 PM, you wrote: TT> On 7/24/07, JJ <[EMAIL PROTECTED]> wrote: >> Yes it were returning same number all the time, I've broke down calculations >> of UTC to Julian date type and saw significant floating point errors >> (rounding) in calculation, it co

Re: [sqlite] problem with date/time

2007-07-24 Thread Trevor Talbot
On 7/24/07, JJ <[EMAIL PROTECTED]> wrote: Yes it were returning same number all the time, I've broke down calculations of UTC to Julian date type and saw significant floating point errors (rounding) in calculation, it couldn't hold such numbers and to me seemed to ignore double data type, but

Re: [sqlite] problem with date/time

2007-07-24 Thread JJ
Yes it were returning same number all the time, I've broke down calculations of UTC to Julian date type and saw significant floating point errors (rounding) in calculation, it couldn't hold such numbers and to me seemed to ignore double data type, but used float instead. (i've played through bun

Re: [sqlite] problem with date/time

2007-07-23 Thread Trevor Talbot
On 7/23/07, JJ <[EMAIL PROTECTED]> wrote: Hi, I am having problems with my compiled sqlite (win32/vs2005). All was working fine until I needed to use date/time functions, following sql always returns same date/time (date part is correct only time was pointing to 18:00) SELECT strftime( '%s', '

[sqlite] problem with date/time

2007-07-23 Thread JJ
Hi, I am having problems with my compiled sqlite (win32/vs2005). All was working fine until I needed to use date/time functions, following sql always returns same date/time (date part is correct only time was pointing to 18:00) SELECT strftime( '%s', 'now') After diging source code with debuger