On 12 Apr 2018, at 1:25pm, Csányi Pál <csanyi...@gmail.com> wrote: > SELECT CASE TheDate = date('now') WHEN TheDate ...
I don't think that's what you wanted. Perhaps SELECT CASE TheDate WHEN date('now') ... But you should test the output of "date('now')" to make sure it is in the format you want. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users