Archives of the TeradataForum

Message Posted: Fri, 17 Jul 2009 @ 10:07:13 GMT


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

Subj:		Re: Rounding up values in terdata

From:		Dieter Noeth

Amarnath S wrote:

I need help in rounding the values

For example: i have 0.15672 and I need to round it up to 1 Similarly I have 2.1243 and I have to round it upto 3 Similary 2.34 to 3 and 4.0123 to 4

That's not rounding, looks like you want the CEILING, which is not implemented in Teradata.

But "4.0123 to 4" doesn't fit at all...

Dieter


	<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

2009 Indexes

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

Last Modified: 15 Jun 2023