[MonetDB-users] Problem with YEAR, MONTH, DAY functions
roulad10 at gmail.com
Thu Oct 20 00:52:25 CEST 2011
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...
More information about the users-list