15 Mar
2013
15 Mar
'13
5:26 p.m.
Hi, When I run this: SELECT DISTINCT(EXTRACT(QUARTER FROM o_orderdate)) FROM orders;
I get following error: Error: syntax error, unexpected IDENT in: "select distinct(extract(quarter" SQLState: 42000 ErrorCode: 0
Is Quarter not supported or is this a bug? Extract Year, month, day are all working fine.
Environment: RHEL (Amazon Linux), Latest version of MonetDB compiled from source code.
Thanks, Diethard