>>> (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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users