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 datetime('now'), or current_timestamp, the time is
> not correct. However, it works correctly when using the sqlite3 program
> (sqlite-3_5_9.zip from download page). Right now I use the SQLite dll
> (sqlitedll-3_5_9.zip) in my code, but I also tried with the source code
> amalgamation with the same results <sqlitedll-3_5_9.zip>
Your code looked correct, so I tried to reproduce the problem: I
complied the sample code you provided using Visual Studio 2005 and the
v3.5.9 amalgamation. Running under XP, I got the expected result:
DATETIME('NOW') = 2008-07-14 18:29:49
I assume that you are running under some flavor of Windows, since you
are using sqlitedll. Perhaps start by adding some traces to SQLite
function "winCurrentTime()"?
Good luck,
Eric
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
