Year Function of MSSQL DateTime field
Year we can read from MSSQL datetime field by using year function . Query is here
select Year(issue_dt) as Year, issue_dt from dt
The output is here
We have seen how month function is used along with group by function. Let us try to list out number of issues in the Year 2010 against months by using group by command and where clause. Here is the query
|2007|| 12/28/2007 7:54:56 PM |
| 2010 || 10/31/2010 7:23:47 PM |
| 2010 || 10/31/2010 7:30:14 PM |
| 2010 || 10/31/2010 7:30:20 PM |
| 2010 || 2/28/2010 7:54:56 PM |
select COUNT(issue_dt) as no, Month(issue_dt) as isdt from dt WHERE Year(issue_dt)='2010' GROUP BY Month(issue_dt)
The left column is the month and next column shows number of issues against that month for the year 2010.
This article is written by plus2net.com team.
Be the first to post comment on this article :