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
