RE: Truncating Result for reporting

Posted in 1997

Bryan Allison — 10 Dec 1997 08:23:10 -0500 — source: Informix-list mailing list archive (1991-1998)

Informix has two functions that you might be able to use. round(value, precision) example round(24,536.879, 2) = 24,536.88 or truncate(24,536.879,2) = 24,536.87 Hope this helps. Bryan Allison Greenbrier & Russel bryana@america.net -----Original Message----- From: INDECO ENGINEERS PTE LTD - VEHICLES & EQUIPMENT DIVISION [SMTP:ieplved@singnet.com.sg] Sent: Wednesday, December 10, 1997 1:39 AM To: informix-list@rmy.emory.edu Subject: Truncating Result for reporting To : All informix experts Can someone teach me how to truncate a mathematics calculation for reporting purposes? Is such feature available in Informix. Kindly advise. Katherine email : ieplved@singnet.com.sg Thanks Thanks ......