Home » Blog
date @@@.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 »

Share |

©2002-2018 ZABKAT LTD, all rights reserved | Privacy policy | Sitemap