On 7/5/18, Jeffrey Mumford wrote:
>
> It appears that when querying from long text fields, sqlite assumes the
> first instance of the field is the length of all subsequent fields.
When you use ".mode column", it has to make some assumptions along
those lines. I suggest you set ".mode quote" or
This will however only work in all GMT/UT1/UTC.
If the "input" (ie, the string) is "localtime" then the localtime modifier
needs to be added to the date() function as in:
date(date_type, 'unixepoch', 'localtime') like '2018-%'
Note that you cannot create an index on the expression
Keith wrote:
> Correct.
> You have stored integer Unix Epoch timestamps. You cannot do "string"
> searches on integers (at least not ones like what you have asked for,
> which involves conversion of an integer representing a Unix Epoch offset
> to an ISO-8601 string, not to an ordinary "string
danap wrote:
> SELECT CAST((SELECT (julianday('now', 'localtime') -
> julianday('1970-01-01'))*24*60*60*1000) AS INTEGER);
Keith wrote:
> Are you sure you want to be mixing up timezones?
>
> julianday('1970-01-01') returns the julianday timestamp
> for 1970-01-01 00:00:00 GMT julianday('now',
On 07/06/2018 03:59 AM, Charles Leifer wrote:
In section 2, the docs read:
The default is:
RANGE BETWEEN UNBOUNDED PRECEDING TO CURRENT ROW
I believe it should read instead:
RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
Thanks. Now fixed here:
On 7/5/18, Jeffrey Mumford wrote:
> Version info:
>
> -- Loading resources from /root/.sqliterc
Can you please show us what you have set inside of /root/.sqliterc?
> SQLite version 3.14.2 2016-09-12 18:50:49
> Enter ".help" for usage hints.
>
> Issue:
>
> It appears that when querying from
Feature request: A function to read the value of db->u1.isInterrupted
The purpose of this is so that extensions that implement additional SQL
functions and/or virtual tables that use loops that aren't VDBE programs can
still know that it is interrupted.
For example, if the extension uses libcurl
Version info:
-- Loading resources from /root/.sqliterc
SQLite version 3.14.2 2016-09-12 18:50:49
Enter ".help" for usage hints.
Issue:
It appears that when querying from long text fields, sqlite assumes the first
instance of the field is the length of all subsequent fields.
The result is
Hi,
I play with sqltclsh.exe and vfs apndvfs and is working fine on windows.
I can have one exe file with my app with TCL scripts inside.
Problem is depend of tcl86t.dll and I want to Static linked in sqltclsh.exe.
I compile TCL with
nmake -f makefile.vc clean OPTS=static,symbols,msvcrt
9 matches
Mail list logo
