Ah, no, you can't do that. The stuff you put into slots are values,
not sql expressions. You could call get-universal-time and somehow
convert that to the same time system that now() is supposed to return,
but you can't put a call in a slot.
Best,
Marijn
On Tue, Dec 25, 2012 at 9:47 PM, Julien Da
On Tue, Dec 25 2012, Marijn Haverbeke wrote:
> If I do
>
> cl-user> (s-sql:sql (:now))
>
> It produces "now()" for me.
Sure, for me too. So let me give you a bit more context.
If you've a class like:
(defclass user ()
((mytimestamp :col-type timestamp :accessor mytimestamp))
(:metaclass dao-c
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 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()
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 wo
Doesn't (:now) work?
On Tue, Dec 25, 2012 at 9:22 PM, Julien Danjou wrote:
> Hi,
>
> I'm trying to use NOW() as a value in an update statement using the DAO.
> I've tried of syntax combinations, but I can't get the right one.
>
> Hint?
>
> --
> Julien Danjou
> /* Free Software hacker & freelance
