Converting a type (e.g. Decimal) BEFORE writing to ResultSet ?

From: George Dainis <george.dainis_at_bluecorner.com>
Date: Wed, 16 Feb 2005 01:48:30 +0100
Message-ID: <cuu58t$irh$04$1_at_news.t-online.com>



As well known a DATE or TIMESTAMP type can be converted (to VARCAHR) after selection but BEFORE writing to the ResultSet by using the CONVERT function e.g.

SELECT CONVERT(char(10), MYTIMESTAMP, 101)) FROM ... WHERE ....

Is there something similar if the original field is a DECIMAL/NUMERIC field?

E.g.

SELECT DEC_CONVERT(char(30), MYDECIMAL, '###########0.00') FROM ..... WHERE ....

George Received on Wed Feb 16 2005 - 01:48:30 CET

Original text of this message