SQL Date range Question

Question

I want to show data from the last month (not form months past though), this month and any futures data in my report. In a SQL view, how can you do this with the date fields called date?

What SQL implementation?

JNK
– JNK

2011-09-26 18:35:25 +00:00
Commented Sep 26, 2011 at 18:35 — JNK
– JNK, Commented Sep 26, 2011 at 18:35

Andriy M · Accepted Answer · 2011-09-26 20:08:19Z

2

Alternatively in SQL Server you could use this simple comparison:

…
WHERE DateColumn >= DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE()) - 1, 0)
…

answered Sep 26, 2011 at 20:08

Andriy M

78k18 gold badges100 silver badges157 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

JNK Over a year ago

I +1'd from your original comment on my answer. Pretty large logical issue that you addressed.

Tony · Accepted Answer · 2011-09-26 18:36:21Z

1

I'm assuming you are using SQL Server, in which case use the DATEDIFF function to see if the date in your table is within the range you want to display.

Information on the function can be found here: http://msdn.microsoft.com/en-us/library/ms189794.aspx

answered Sep 26, 2011 at 18:36

Tony

10.4k3 gold badges51 silver badges78 bronze badges

Comments

Ujjwal Manandhar · Accepted Answer · 2011-09-26 18:36:19Z

-1

there is a built in function in SQL Server to add the date .. and for your date field named as date select it as [date]

answered Sep 26, 2011 at 18:36

Ujjwal Manandhar

2,25417 silver badges20 bronze badges

1 Comment

JNK Over a year ago

This isn't really an answer. This is like someone asking how to change the oil in their car and your response is "You just change it".

Collectives™ on Stack Overflow

SQL Date range Question

3 Answers 3

1 Comment

Comments

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Related