Hi ;
FB 2.1


is there a function about date's month with firebird?how can i get the
current date's month and week ?can i use like this a sorting

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

thanks.