Re: [sqlite] Datetime issue with the time part

2008-07-15 Thread Sebastien Robillard
Eric Minbiole wrote: > From what you describe, it seems that the compiler is performing > single-precision, rather than double-precision, math. After a quick > Google search, I found a few posts indicating that Direct3D silently > switches the FPU from double to single precision math,

Re: [sqlite] Datetime issue with the time part

2008-07-14 Thread Sebastien Robillard
Eric Minbiole wrote: > Sebastien Robillard wrote: > >> Hi everyone, >> I have an issue with datetimes that doesn't return the "time" part >> correctly (always 00:00:00 or 18:00:00) when I use SQLite in my C++ >> code. Whenever I use datetim

[sqlite] Datetime issue with the time part

2008-07-14 Thread Sebastien Robillard
Hi everyone, I have an issue with datetimes that doesn't return the "time" part correctly (always 00:00:00 or 18:00:00) when I use SQLite in my C++ code. Whenever I use datetime('now'), or current_timestamp, the time is not correct. However, it works correctly when using the sqlite3