0 - 5 of 5 tags for float

I have a numeric value which I want to divide by 1000:

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.

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

I have to do the following transformation



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