Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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'
Solved! Go to Solution.
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).
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).
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |