Re: ROUND function

Hi Jeff
I have no problem to say it was me. Your answer is much better, thanks. I have altered the VOQL-TEG answer with your comments. Please feel free to do any other change if still needed.
Cheers
Iñaki

Jeff Lusted wrote:
> Hi Colleagues!
>
> I'm not sure who answered Mark's question on the ROUND function.
> Depending on how you read the answer, the answer is ambiguous...
>
> how come the round(x,n) ("Round to nearest integer") function has two
> arguments?
> VOQL-TEG Answer: This is an error and will be corrected in the next
> version of the document.
>
> There is an error, but I'm not sure which bit is thought to be an error
> in the document. I think it is "Round to nearest integer", which is far
> too restrictive. The function with two args is supported as far as I
> know by the main manufacturers (both parameters are required in SQL
> Server). My understanding is it rounds to the given number of decimal
> places, with the default being to round to the nearest integer. You use
> a negative number to round to the left of the decimal point.
>
> I didn't want to alter over another member of the TEG, so please alter
> the answer, kind colleague!
>
> Kindest regards
> Jeff
>

-- 
Iñaki Ortiz de Landaluce

European Space Agency (ESA)
European Space Astronomy Centre (ESAC)
Science Operations Department (SCI-O)
Science Archives Engineering Unit (SCI-OE)

E-mail: Inaki.Ortiz-at-sciops.esa.int
Tel: +34 91 813 13 67  Fax: +34 91 813 13 22

European Space Astronomy Centre (ESAC)
28691 Villanueva de la Cañada
P.O. Box 78, Madrid, SPAIN 


================================================================================================
This message and any attachments are intended for the use of the addressee or addressees only. The
unauthorised disclosure, use, dissemination or copying (either in whole or in part) of its content
is prohibited. If you received this message in error, please delete it from your system and notify
the sender. E-mails can be altered and their integrity cannot be guaranteed. ESA shall not be liable
for any e-mail if modified.
=================================================================================================