[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

Re: Sybase date conversion



Hi!
select datepart(month,getdate())
go

will return current month.

Your query should look like this..
select sum(....)
from ...
where ....
group by datepart(month,column_name)

Milan Mircetic.