Year in MSSQL DateTime function with Where clause

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

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

select COUNT(issue_dt) as no, Month(issue_dt) as isdt from dt WHERE Year(issue_dt)='2010' GROUP BY Month(issue_dt)

isdt	no
2	1
10	3

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 :

plus2net.com

MSSQL Date & Time function Examples

Inserting present date and time in a field by default

How to format Date & Time variable to insert into MSSQL table

DatePart to get part of a date & time field of MSSQL record

Updating MSSQL date & time field

DateDiff: Getting the Difference in days, month and year between two date fields

Month: Month in numbers from DateTime field

Year: Year from DateTime field

Day: Day from DateTime field

Example of Date Query: Last n days record, todays records