Hi,
Thanks for your help! It is a bug. Actually it is not only with date
functions, but with all kinds of operations. I found the problem, it
will be fixed in the next release. With the current version, you can
not order by a formula when the formula is in the group by list but
not in the select list. A workaround is to include the expression in
the select list:
drop table t if exists;
create table if not exists t (d date);
insert into t values ('2008-11-01'), ('2008-11-02');
select null, year(t.d) from t group by year(t.d) order by year(t.d);
Regards,
Thomas
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en
-~----------~----~----~----~------~----~------~--~---
