TUTORIALS POINT Simply Easy Learning 8 YYYYMMDD HHMMSS 20101230 121001 9 Now 2013-05-07 You can use the "T" as a literal character separating the date and the time. Modifie�s The time now using SQLite prompt. Following computes the current date: sqlite> SELECT date('now'); 2013-05-07 Following computes the last day of the current month: sqlite> SELECT date('now','start of month' signing of the US Declaration of Independence: sqlite> SELECT julianday('now') - julianday('1776-07-04'); 86504.4775830326 Following computes the number of seconds since a particular moment in 2004:

username FROM z$log WHERE status=403; scheme|username | aragorn|{"scheme_type":"internal","dbfile":"t07c82fec97b103c9c2420be9"} aragorn|{"scheme_type":"internal","dbfile":"t562430406c732c3fbb9bc2be"} ar frodo|{"scheme_type":"internal","dbfile":"tbb3cdadf930fee621bdc97"} gandalf|{"scheme_type":"internal","dbfile":"t07c82fec97b103c9c2420be9"} saruman|{"scheme_type":"internal","dbfile":"tbb3cdadf930fee621bdc97"} stri