Hi,

> is there a function about date's month with firebird?

there are some internal, it depends on your FB version. and there are tens
of it on UDFs

> how can i get the current date's month

extract(month from current_date)

> and week ?

day of week or week number on year?? day of week you can get like this:

extract(weekday from current_date)


On dates, extract can also be used with DAY or YEAR.

ex:

select extract(month from date)
from table
group by 1


Regards,
Anderson Farias