All Forums Database
indra91 16 posts Joined 06/16
21 Jul 2016
Real/DoublePrecision/FLoat type in Teradata

In the reference of Teradata I could see numeric data types like Real,Double Precision,Float.But I could see example of only Float data.Can anybody point out whether all the three refers to the same type.In case the answer is in negative could you cite an example of a Real/Double Precision type?

Fred 1096 posts Joined 08/04
21 Jul 2016

REAL and DOUBLE PRECISION are ANSI standard syntax, interpreted as identical to Teradata FLOAT.

indra91 16 posts Joined 06/16
21 Jul 2016

Thanks Fred.So we can define a column as float in Teradata but it is not possible to define a column with data type as REAL?Is the understanding correct?

Fred 1096 posts Joined 08/04
22 Jul 2016

You can use the keyword REAL or DOUBLE PRECISION in the CREATE TABLE; the resulting column data type will be FLOAT.

You must sign in to leave a comment.