> I've got data in a table containing timestamps in a timestamp column. I > want to group these by month. > > How? > > Anything simpler/better than this: > substring(cast(T."TheTimestamp" as varchar(50)) from 1 for 7)
select count(*) , extract(month from mytimestamp) from t group by extract(month from mytimestamp) You can speed up things on a large table by adding an expression index. HTH. -- With regards, Thomas Steinmaurer * Upscene Productions - Database Tools for Developers http://www.upscene.com/ * My Blog http://blog.upscene.com/thomas/index.php * Firebird Foundation Committee Member http://www.firebirdsql.org/en/firebird-foundation/
