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 bunch of compiler settings, pragmas, etc with no significant gain). Actually tried my own calculation which operates with smaller numbers, but in the end when result should be stored, numbers got messed again. Damn, I didn't meant to spend 4 hours on this...
I've abandoned msvc compiler and using trial intel compiler for now... No problems on new compiler with calculations.. On Tue, 24 Jul 2007 02:13:46 +0300, Trevor Talbot <[EMAIL PROTECTED]> wrote: > 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] > ----------------------------------------------------------------------------- > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
