Alter Data type for existing column in a table

Database
Enthusiast

Alter Data type for existing column in a table

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'?

WHERE Start_Date=CURRENT_DATE-30

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'

Please help!

Thanks!

Tags (2)
2 REPLIES 2
Teradata Employee

Re: Alter Data type for existing column in a table

Use >=

Teradata Employee

Re: Alter Data type for existing column in a table

Or BETWEEN -- WHERE Start_Date between CURRENT_DATE-30 and CURRENT_DATE -- in case some Start_Dates are in the future.