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
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
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')
3 matches
Mail list logo