SQL Year Date Query

Question

I am working on a SQL server and I have a list of dates in the format of 2015-03-17 how would I query the database so that only events that occurred in 2015 show up

Please try something on your own first. This is an extremely basic query that is readily available on Google and in any SQL Server resource. — dfundako, Sep 19 '16 at 17:48

score 3 · Answer 1 · edited May 23 '17 at 11:53

3

You might get better results by trying:

SELECT *
FROM TABLE
WHERE DateField >= '2015-01-01 00:00:00'
    and DateField < '2016-01-01 00:00:00'

This has a higher chance of being "sargable", if you have a index on that column, rather than applying a function over your DateField, which will most certainly bypass using the index.

edited May 23 '17 at 11:53

Community

1
1

answered Sep 19 '16 at 17:47

Radu Gheorghiu

20,049
16
72
107

Got it, I see your update :). Deleted my comment and tossed in an upvote to get you positive. This is a nice answer. – JNevill Sep 19 '16 at 17:49
@JNevill Thanks =) – Radu Gheorghiu Sep 19 '16 at 17:50

score 1 · Accepted Answer · answered Sep 19 '16 at 17:46

1

You should add this in your queries:

YEAR(DateField) = 2015

answered Sep 19 '16 at 17:46

Rubens Farias

57,174
8
131
162

Actually, you shouldn't, and [**here's why**](http://stackoverflow.com/questions/799584/what-makes-a-sql-statement-sargable). – Radu Gheorghiu Nov 11 '16 at 08:49

score 0 · Answer 3 · answered Sep 19 '16 at 17:46

0

Select * from YourTable where Year(SomeDateField)=2015

answered Sep 19 '16 at 17:46

John Cappelletti

79,615
7
44
66

Black Mamba · Answer 4 · 2016-09-19T17:51:48.423

0

Select * from YourTable where Date(SomeDateField)>2015 And Date(SomeDateField)<2016; This helps find date between two years 2015 and 2016

edited Sep 19 '16 at 17:51

answered Sep 19 '16 at 17:49

Black Mamba

13,632
6
82
105

Why? Why not just `=2015`? – JNevill Sep 19 '16 at 17:51
He has explicitly given date so date can't be taken directly 2015. – Black Mamba Sep 19 '16 at 17:53

SQL Year Date Query

4 Answers4