>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)

You can use extract to do that

Select extract(month from datefield) from table
Group by 1

Same
Select extract(year from datefield) from table
Group by 1;

Select extract(day from datefield) from table
Group by 1;

You can combine...

Regards,
Paul