I am just thinking there must be some smarter way how to get the date
information only (not the time) from the timestamp then :

SELECT
(CAST (((extract (DAY FROM DATE))||'.'||(extract (MONTH FROM
DATE))||'.'||(extract (YEAR FROM DATE))) AS DATE)) NEW_DATE
........

I mean timestamp stored in the database is something like:
21.12.2004 08:45:56

and I want to receive as a return from the SELECT command:
21.12.2004 00:00:00

Or some other suggestions how to "GROUP BY" timestamp if I need to
group by days if the timestamp is the only time info in the database?

I am working with FB 1.5 (dialect 1)

Thanks for your comments

Petr Jakes