Message: 25
Date: Thu, 20 Sep 2012 07:44:00 -0600
From: "Keith Medcalf" <kmedc...@dessus.com>
To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org>
Subject: Re: [sqlite] select ... where problem
Message-ID: <dccc8dcdf36303448ae1d39bb3070...@mail.d
>>> (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
On Donnerstag, 20. September 2012 15:16:29, 叶艳红 wrote:
> insert into history (mdwkup,macdup,mdate,mdwkmd) SELECT
> (select count(*) FROM fxj where mdwkup=1),
> (select CURDATE()),
> (select round(avg(mdwkmd),2) from fxj) where datetime('now',
> 'localtime')>15:00
>
> The sql command could not run
insert into history (mdwkup,macdup,mdate,mdwkmd) SELECT
(select count(*) FROM fxj where mdwkup=1),
(select CURDATE()),
(select round(avg(mdwkmd),2) from fxj) where datetime('now',
'localtime')>15:00
The sql command could not run
___
sqlite-users
4 matches
Mail list logo