If I do
cl-user> (s-sql:sql (:now))
It produces "now()" for me.
On Tue, Dec 25, 2012 at 9:36 PM, Julien Danjou julien@danjou.info wrote:
On Tue, Dec 25 2012, Marijn Haverbeke wrote:
Doesn't (:now) work?
No, I get:
Value (:NOW) can not be converted to an SQL literal.
I've actually tried "NOW()", which is a string and seemed not valid to me so I just didn't try that possibility, and it seems to work… But I'm worring of what would happen if my field was not a timestamp but a text?
-- Julien Danjou ;; Free Software hacker & freelance ;; http://julien.danjou.info