Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!usc!apple!agate!shelby!portia.stanford.edu!chesky
From: chesky@portia.Stanford.EDU (Snehylata Gupta)
Newsgroups: comp.databases
Subject: Re: Ingres money functions?
Message-ID: <1990Jun13.001938.5550@portia.Stanford.EDU>
Date: 13 Jun 90 00:19:38 GMT
References: <147@stephsf.UUCP>
Organization: AIR, Stanford Universit
Lines: 28

In article <147@stephsf.UUCP> wengland@stephsf.UUCP (Bill England) writes:
>
> In Ingres esql my query is returning a type money into a c type of double.
> How can I manipulate the money value??  ie add, sub, mul ??
> How can I convert it into a float or truncate it into an integer?
>
> Code examples would be greatly appreciated.
>
>
>  Thanks in advance!
>
> +--------
> |  Bill England
> |  Stephen Software Systems, Inc.,   Tacoma Wa.

The following will work

The following will work

float4_var = float4(money_var)
or
float8_var = float8(money_var)
converts to float type variables
to convert to integer the function names are int1, int2 and int4
which convert the datatype to the appropriate integer types.


Sanjay using this account temporarily.