Archives of the TeradataForum

Message Posted: Wed, 23 Jul 2008 @ 13:01:40 GMT


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

Subj:		Re: How to Achieve the decimal part

From:		Victor Sokovin

In Oracle MONTHS_BETWEN() will give result in fractions like xx.yyyy I am trying to calculate months between two dates in teradata but I unable get the fraction value i.e simply its giving xx but can we get the result in fractions in TD .

I can get the months in days and we can divide it with 30 we will get some approximate value but its not accurate.

Try 31.

Victor


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

Archives

2016		2007
2015		2006
2014		2005
2013		2004
2012		2003
2011		2002
2010		2001
2009		2000
2008		1999

2008 Indexes

Jan		Jul
Feb		Aug
Mar		Sep
Apr		Oct
May		Nov
Jun		Dec

Last Modified: 15 Jun 2023