View Single Post

   
  #1 (permalink)  
Old 04-19-2008, 07:40 PM
Ravi Krishna
 
Posts: n/a
Default storing the value of PI

I am converting a SQL Server stored procedure to Informix.
In SQL Server there is a function PI() which returns 3.1415926535897931
and this can be used in a SQL Server FLOAT variable.
When I try to create a datatype in Informix to store the same value,
it seems the best I could do is to create FLOAT(16) and it can only
take 3.141592653590. Is there a data type in Informix which can take
the precise value of PI. Am I missing something?

Thanks.

Ravi



Reply With Quote