Tuesday, July 28, 2009

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

No comments: