Re: [sqlite] localtime on current_time differs from localtime on current_timestamp

2019-09-26 Thread Adrian Ho
On 26/9/19 11:51 PM, Keith Medcalf wrote: > So, when you ask for time(current_time, 'localtime') you are saying to > get the current utc datetime, discard the date part, then assume that > the date part is 2000-01-01 with that time, then compute the > "localtime" for that UTC time, and then discard

Re: [sqlite] localtime on current_time differs from localtime on current_timestamp

2019-09-26 Thread Keith Medcalf
On Thursday, 26 September, 2019 05:33, PALAMARA Alain wrote: >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 sim

[sqlite] localtime on current_time differs from localtime on current_timestamp

2019-09-26 Thread PALAMARA Alain
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')