extracting date from an timestamp value in firebird

you can use the cast to extract the date from timestamp

SELECT cast('now' as date)
FROM rdb$database

in my case the result is

28.07.2009

someone asked on webhostingtalk how to do it

also you can extract only the year or month using the extract function