Pawl <[email protected]> wrote: > I don't know that sqllite save TIMESTEMP as string, problem is with > counting i have to use helpful function > like as strftime('%s',timestampevar) .. but ... comparative operator <> = > BETWEEN is right.
It only seems this way, because all dates in your sample database happen to come the same month and year. Once you work with real dates, you'll discover that '20.02.2012' < '30.01.2010', for example. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
