Forum Discussion
SQL - date range from today until 3 months from now
Hello,
Sorry if this isnt the best forum to ask this, but Im digging into a SQL data warehouse, which uses a date field. The data is populated from 2004 onwards, but I only want to pull the event data for date rows equal or later than TODAY, and less than or equal to 3 months from now. I can hard code the dates (showm below), but I want this to be automatic and ongoing.
Any ideas?
Here's the hard coded exmaple... Whats the SQL code needed to replace the hard dates with Today until 3 months from now?
select *
from TABLE_DETAILS
where EVENT_CODE = 'XS'
and EVENT_DATE between '01-SEP-16' and '01-DEC-16'
From a purely SQL perspective, you want to use
getdate()
to get the current date/time (convert with a mask to eliminate time if necessary)
and
dateadd(month, 3, getdate())
to get the date 3 months from now (use same convert mask if needed).
1 Reply
From a purely SQL perspective, you want to use
getdate()
to get the current date/time (convert with a mask to eliminate time if necessary)
and
dateadd(month, 3, getdate())
to get the date 3 months from now (use same convert mask if needed).