I need to extract the year part of a date field in a IB table.

I went thru the language ref: nothing.

I asked in the SQL_beginners group and had 3 answers:

1st answer:
use Year(), Month(), Day() functions

2nd answer:
look at convert and datepart functions

3th answer:
for Oracle
select TO_CHAR(SYSDATE,'MM'),TO_CHAR(SYSDATE,'DD'),TO_CHAR(SYSDATE,'YY')
FROM DUAL

I went thru the language ref again: no trace of any of those functions.

I tested the function interactively with WISQL: a long sequence of "token
unknown" errors.

Should I conclude that IB lacks a lot of handy functions that all other
RDBMS have ?

Now that I am at it, the list of functions contained in the LangRef looks
rather slim...

What do you think ?

Thank you

Duilio Foschi