0 - 2 of 2 tags for select statement
Last 6 Month in Query - Failing on August 30

...WHERE DB.LOG_DATE > DATE - INTERVAL '6' MONTH;
 
This has been working for weeks, until today. I wasn't sure what broke my script until I tried dropping the date requirement and then it started working perfectly. 6 month ago is February 30, I am guessing, by TD logic, which doesn't exist.
Any general solutions?
 

By aaibinder, 30 Aug 2016 | Tagged: teradata date interval select statement | 2 comments
SELECT statement in FUNCTIONS

Hi Guys,
 
I need to create a function that reads its result from a table, so I need to use a SELECT statement to read the output. Something like that:

By veskojl, 19 Mar 2014 | Tagged: stored procedure function udf select statement