date change in sql

Question

hi I have a date which is 2009-06-02 00:00:00.000 and i want to only group by month ..

how can change it ?!

score 2 · Accepted Answer · answered Feb 03 '10 at 16:08

2

You may want to group by month, but have data that spans more than one year. In that case, I would do:

group by Year(MyDate), Month(MyDate)

answered Feb 03 '10 at 16:08

D'Arcy Rittich

score 0 · Answer 2 · edited May 23 '17 at 11:48

0

use

group by MONTH(record_date)

see this question for more information :

edited May 23 '17 at 11:48

Community

answered Feb 03 '10 at 16:06

Haim Evgi

Note that this'll require the MONTH() function to be executed against every row in the table every time it's requested... – ceejayoz Feb 03 '10 at 16:07
ops sorry month and year without the day !! – user265314 Feb 03 '10 at 16:08
i add a link to similar question that support this – Haim Evgi Feb 03 '10 at 16:10

score 0 · Answer 3 · answered Feb 03 '10 at 16:07

0

SELECT ... GROUP BY MONTH(datecolumn)

answered Feb 03 '10 at 16:07

Yada

3 Answers3