Archives of the TeradataForum

Message Posted: Fri, 29 Feb 2008 @ 20:47:20 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Oh David, you were so close with the date math, however the year is stored as an offset from the year 1900. This year is 108 + 1900 = 2008.

So you would need to do this for current year:

     (current_date/10000+1900) * 10000 + 1231 (date)

or for prior year:

     (current_date/10000+1899) * 10000 + 1231 (date)

Now, with all this said, if he really is trying to back up one year, why not do this:

     add_months(store_year,-12)

It just depends if he is backing up one year or one day in that goofy looking Oracle code using all those functions (my opinion of course...lol)

Regards,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

	<Prev	Next>		<<First	<Prev	Next>	Last>>