Sqlite has DateTime. However, in my test ‘DateTime’ is similar with ‘Text’.<\/p>\n
for example, javascript moment.js,<\/p>\n
\r\n\r\nvar date = new moment().format('YYYY-MM-DD hh:mm');\r\nsaveToDatebase(date);\r\n\r\nvar date = new moment().format('YYYY-MM-DD h:mm a');\r\nsaveToDatebase(date);\r\n\r\n<\/pre>\nin sqlite, two different format will saved as different string.<\/p>\n
it is better not to compare two different format,<\/strong> such as ‘2016-10-10’ and ‘2016-10-10 10:10:10’. it is comparable, but it is meanless.<\/p>\ntherefore, in my test, and date time should be save as YYYY-MM-DD hh:mm, such as ‘2016-10-10 10:10’ format.<\/p>\n
then, sql statement like ‘select * from test where startDate < '2016-10-10 15:15' will work perfectly well.\n\n<\/p>\n","protected":false},"excerpt":{"rendered":"
Sqlite has DateTime. However, in my test ‘DateTime’ is similar with ‘Text’. for example, javascript moment.js, var date = new moment().format(‘YYYY-MM-DD hh:mm’); saveToDatebase(date); var date = new moment().format(‘YYYY-MM-DD h:mm a’); saveToDatebase(date); in sqlite, two different format will saved as different string. it is better not to compare two different format, such as ‘2016-10-10’ and ‘2016-10-10 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13],"tags":[],"class_list":["post-252","post","type-post","status-publish","format-standard","hentry","category-javascript"],"_links":{"self":[{"href":"http:\/\/emacslisp.com\/index.php?rest_route=\/wp\/v2\/posts\/252","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/emacslisp.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/emacslisp.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/emacslisp.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/emacslisp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=252"}],"version-history":[{"count":4,"href":"http:\/\/emacslisp.com\/index.php?rest_route=\/wp\/v2\/posts\/252\/revisions"}],"predecessor-version":[{"id":256,"href":"http:\/\/emacslisp.com\/index.php?rest_route=\/wp\/v2\/posts\/252\/revisions\/256"}],"wp:attachment":[{"href":"http:\/\/emacslisp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=252"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/emacslisp.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=252"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/emacslisp.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=252"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}