| Subject | Group by month based on a timestamp? |
|---|---|
| Author | Kjell Rilbe |
| Post date | 2011-12-15T14:21:51Z |
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)
Kjell
--
------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64
want to group these by month.
How?
Anything simpler/better than this:
substring(cast(T."TheTimestamp" as varchar(50)) from 1 for 7)
Kjell
--
------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64