Home » Blog
@@@.Jan.2018
■ @@@ Some title
small self-contained without a separate server process
how to deal with unicode, avoid x16 functions, large file without return
for case conversion compile with ICU? dev pistebw, 1 language at a time?
https://stackoverflow.com/questions/6578600/how-to-compile-sqlite-with-icu
blog: about sql and date matching
maintain compatibility with windows search query language
https://stackoverflow.com/questions/53131975/querying-sqlite-database-for-dates
a little work required to make it unicode LOWERCASE
quote
TEXT as ISO8601 strings ("YYYY-MM-DD HH:MM:SS.SSS").
•REAL as Julian day numbers, the number of days since noon in Greenwich on November 24, 4714 B.C. according to the proleptic Gregorian calendar.
•INTEGER as Unix Time, the number of seconds since 1970-01-01 00:00:00 UTC.
@@@
VS build C++ remember to disable precompiled headers for sqlite3.c
sqlite, deskrule, no date types, how to store and compare, docs aren't clear
https://www.sqlite.org/datatype3.html
juliandate use FileTimeToSystemTime then computeJD from source code amalgamation
problem with case sensitive
ISO dates like YYYY-MM-DD HH:MM:SS
they compare as text
https://www.sqlite.org/lang_datefunc.html strftime doesn't work
best REAL for space considerations
might as well store FILETIME straight and forgo date string comparisons
CREATE TABLE dir(
id INTEGER PRIMARY KEY,
filename TEXT NOT NULL,
size INT,
modified REAL);
-- add items...then query for dates modified
SELECT * FROM dir WHERE modified <= julianday('2018-11-02 00:00:00');
Post a comment on this topic »