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', 'now')

So it's always returning 1185213600 exactly?

After diging source code with debuger, I found out that my top of the line 
OS/Compiler/CPU couldn't handle data type double. I've tried all possible 
floating point models, with and without SSE, nothing seems to allow it handle 
data with any significant precision.

There's nothing technically wrong with vs2005 on x86.  I suspect the
problem is with algorithmic conversion somewhere, not the data type.

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to