>>> (select CURDATE()), What is a CURDATE()? Is that a custom scalar function of your own? Did you remember to compile it into the engine or load the module containing the function?
>>> where datetime('now', 'localtime') > 15:00 15:00 is unparseable. Perhaps you mean >>> where datetime('now', 'localtime') > '15:00' But if so you can elimate the where clause entirely because '2' is always greter than '1' ... I am surprised the "Error Message" did not point out these errors. --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users