I need to run a specific query if the date is the ninth of the month. A different query would need to be run if the date is any other date except the ninth. I wanted to please ask for the syntax to do this with Teradata.
Something like this is what I need (using MS SQL syntax):
IF ( day(getdate()) = 9)
Begin Select * From Table End
Begin Select *From AlternativeTable End