[MonetDB-users] Problem with YEAR, MONTH, DAY functions

Roula Avg roulad10 at gmail.com
Thu Oct 20 00:52:25 CEST 2011


Hello,
sorry to ask again but i have problem with YEAR, MONTH and DAY functions.
According to the references YEAR for example can take as argument a date or
a timestamp or a month_interval value. So if i run the query:
sql> select year(current_timestamp); or sql> select year( '2002-03-21') it
should return 2011 and 2002. Instead of this, i take: *syntax
error,unexpected YEAR in: "select year". *What am i doing wrong?

Thank you very much in advance
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20111020/e88743c6/attachment.html>


More information about the users-list mailing list