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
| Year | issue_dt |
|---|
| 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.
Be the first to post comment on this article :
|
