ansaurus

Question

date change in sql

Answer 1

A:

use

group by MONTH(record_date)

see this question for more information :

Haim Evgi 2010-02-03 16:06:27

Note that this'll require the MONTH() function to be executed against every row in the table every time it's requested...

ceejayoz 2010-02-03 16:07:16

ops sorry month and year without the day !!

2010-02-03 16:08:28

i add a link to similar question that support this

Haim Evgi 2010-02-03 16:10:52

Answer 2

A:

SELECT ... GROUP BY MONTH(datecolumn)

Yada 2010-02-03 16:07:15

Answer 3

+2 A:

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)

RedFilter 2010-02-03 16:08:15

Answer 4

A:

GROUP BY MONTH(yourdate)

kevchadders 2010-02-03 16:09:29

i want it in the select !! like select vender month and year of the duedate ... the duedate is a full daye like 2009-06-02 00:00:00.000

2010-02-03 16:13:10

date change in sql