Brad, Puneet,
Thanks for getting back to me so quickly. I feel like a fool ;-)
The error of "misuse of aggregate function MAX()" confused me. I ran the
same query in SQL Server, got an error message that I understood and
realised instantly that my brain wasn't switched on and that I needed to
On 12/4/08, Brad Stiles <[EMAIL PROTECTED]> wrote:
> > SELECT *
> > FROM MyTableWithDates
> > WHERE datetime("now") > MAX(dtEndDate)
>
>
> What is it that you are actually trying to do with this query? As
> formulated (even if it were syntactically correct, which I don't think
> it is), you
> SELECT *
> FROM MyTableWithDates
> WHERE datetime("now") > MAX(dtEndDate)
What is it that you are actually trying to do with this query? As
formulated (even if it were syntactically correct, which I don't think
it is), you are either going to get every row in the table, or no rows
at all.
Hi,
I've been using SQL for years in SQL Server but I've only recently started
using Sqlite. I've got to grip with most of the little differences but I
can't for the life of me figure out how to do a query where I compare the
current date with the maximum date of a field in a table. E.g.
SELECT
4 matches
Mail list logo