Re: Extract quarter from date

16 Mar 2013


      You can obtain list of functions by executing the following query:

select * from sys.functions;

Gennadiy

On Sat, 16 Mar 2013 16:36:23 +0000
Diethard Steiner  wrote:
...
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  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