float

Posted in 2004

Clive Moore — Wed, 26 May 2004 11:47:53 +0000 (UTC) — source: Usenet: comp.databases.informix

can anyone tell me if it is possible to insert a value ending in a decimal zero into a float field in informix using an sql statement without the last character being trimed. eg. 1.10 becomes 1.1 thanks Clive -- Posted via Mailgate.ORG Server - http://www.Mailgate.ORG

↪ replying to Clive Moore

Richard Harnden — Wed, 26 May 2004 14:37:56 +0100 — source: Usenet: comp.databases.informix

"Clive Moore" <helloclive@hotmail.com> wrote in message news:4787b6f194f48bdb4ea6200ee071aa20.35643@mygate.mailgate.org... > can anyone tell me if it is possible to insert a value ending in a > decimal zero into a float field in informix using an sql statement > without the last character being trimed. eg. 1.10 becomes 1.1 Hello Clive, Er, well, the last 0 is insignificant: 1.10 = 1.1, they're the same number. The trailing 0 isn't actually stored... If you want 1.1 to /display/ as 1.10 then you'll need to specify a format, eg, "%1.2f" in C, USING "&.&&" in 4gl Maybe you can cast to a decimal to get a fixed width output in vanilla sql. -- rh