Hi Niels,

Thanks a lot for clarifying this! Is there actually somewhere a detailed listing of all the supported functions? I couldn't find any info on this in the MonetDB SQL Documentation (unless of course I was not looking carefully enough). I was just trying various functions that I know from other DBs to extract the date/time part until I got one of them working, which is a bit tedious. It would be excellent if there was a documentation on date/time and string functions.

Best regards,

Diethard

On Sat, Mar 16, 2013 at 9:54 AM, Niels Nes <Niels.Nes@cwi.nl> wrote:

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

_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list