I have a column called 'Start_Date' which of the data type Date. For example 2/27/2016. How can i find out the last 30 days from the current date for the column 'Start Date'?
The above where clause would only give me the value for just 3/13/2019.
I am needing the values for all the dates between current_date and 3/13/2019 for column 'Start Date'
Or BETWEEN -- WHERE Start_Date between CURRENT_DATE-30 and CURRENT_DATE -- in case some Start_Dates are in the future.