Re: [sqlite] select ... where problem

2012-09-20 Thread YAN HONG YE
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

Re: [sqlite] select ... where problem

2012-09-20 Thread Keith Medcalf
>>> (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

Re: [sqlite] select ... where problem

2012-09-20 Thread Marcus Ilgner
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

[sqlite] select ... where problem

2012-09-20 Thread 叶艳红
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