tag:blogger.com,1999:blog-1556110042987012571.post1484030660623351327..comments2022-12-04T06:09:53.389-05:00Comments on Teradata Tips: Issue in INTERVAL functionMeena Athmanathanhttp://www.blogger.com/profile/15342471362722574934noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-1556110042987012571.post-35862831360613179232011-06-19T01:29:23.515-04:002011-06-19T01:29:23.515-04:00HI mam i got a doubt ..when we are extracting and ...HI mam i got a doubt ..when we are extracting and tranform the data to staging area which one is best ..fastload or bteq...for transform and extract which one is best please tell mechowdayhttps://www.blogger.com/profile/17792968268015149599noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-72570892141134743182011-04-18T17:51:14.480-04:002011-04-18T17:51:14.480-04:00it is not a feature. so, was wondering why can'...it is not a feature. so, was wondering why can't they fix it? does it have any meaningful justification apart from being 'documented'? if add_months is an alternative, why not remove this functionality(interval 'n' month) completely?Meenahttps://www.blogger.com/profile/00121334761996329328noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-71014400920947703852011-04-14T17:51:17.461-04:002011-04-14T17:51:17.461-04:00It is not a teradata bug. According to the teradat...It is not a teradata bug. According to the teradata manual, that is what it is. That is the reason why they have ADD_MONTHS function :-)Vijayakumarhttps://www.blogger.com/profile/17890411599254728203noreply@blogger.comtag:blogger.com,1999:blog-1556110042987012571.post-87622535380368859122011-02-22T10:36:23.555-05:002011-02-22T10:36:23.555-05:00Teradata manual itself says they dont work directl...Teradata manual itself says they dont work directly, so I think they are aware but not sure when they might fix or they have plans of fixing.<br /><br />SQL functions: page 152<br /><br />For example, the following operation returns an error because it evaluates to a date that is not<br />valid (‘1996-09-31’).<br />SELECT DATE '1996-08-31' + INTERVAL '1' MONTH;<br />The desired result is obtained with a slight rephrasing of the second operand.<br />SELECT DATE '1996-08-31' + INTERVAL '30' DAY;<br />This operation returns the desired result, ‘1996-09-30’. No error is returned.Balamurugan Shttps://www.blogger.com/profile/03895456323711144214noreply@blogger.com