Tags for float
Converting Number to Character
By Stiphu, 06 Jan 2014 | 7 comments
I have a numeric value which I want to divide by 1000:
character conversion numeric float
Precision loss during expression evaluation - data type issue?
By tstrick4, 18 Jun 2013 | 2 comments
Hi, when I execute the following SQL
cast decimal float precision 2614 expression evaluation data type data type conversion
Precision error in FLOAT type constant or during implicit conversions
By diogo.capistrano, 15 Jun 2013 | 4 comments
I received this error when i run the query on my app, but when i run the same query on teradata studio, it run fine. Why??? I use jdbc driver for run this query.
jdbc float error conversion
Using SQL to Query for NaN
By Paul.Hooper, 02 Nov 2012 | 1 comment
I have a table (I'll call this DTM) which has a column of the type FLOAT (I'll call this VAL).  This table currently includes rows in which the value of that column is NaN (not a number).  We are inserting these values through DataStage / Java, which is taking the values of "NaN", "+Infinity" and "-Infinity" (all legit IEEE 754 floats) from a text file an
database sql float nan
float data type in teradata
By TD_DEV245, 31 Aug 2012 | 1 comment
I have to do the following transformation Round(sum(column),2)   The datatype of column is float.. Round() function is available in oracle. --How to implement this requirement in Teradata.Should I use CAST()? I have another query: Suppose the column contains values like 20.123456
oracle datatype float round() cast()