On Fri, Mar 15, 2013 at 05:26:53PM +0000, Diethard Steiner wrote:
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
_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list
The EXTRACT functionality is limited to Year, Month, day, hour, minute, and second. Niels -- Niels Nes, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl