Hello, I'm quite new to sqlite and I'm surprised about the result I got from executing time(current_time, 'localtime') function.
I use the sqlite3 command line (version 3.29.0) on Windows 7 and I tried to get my local time using this simple statement: select time(current_time, 'localtime'); and the result was wrong. I did tried with: select time(current_timestamp, 'localtime'); and the result was right. Is that behavior normal or is that a bug? To reproduce it, here is the output of my complete test: sqlite>select time(current_timestamp), time(current_time), time('now'); time(current_timestamp) time(current_time) time('now') ----------------------- ------------------ ----------- 10:47:40 10:47:40 10:47:40 sqlite>select time(current_timestamp, 'localtime'), time(current_time, 'localtime'), time('now','localtime'); time(current_timestamp, 'localtime') time(current_time, 'localtime') time('now','localtime') ------------------------------------ ------------------------------- ----------------------- 12:47:44 11:47:44 12:47:44 As you can see, the localtime for current_time is one hour shifted from the two others despite the "raw" results are the same. Regards, Alain _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users