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

George Dainis · *nix forums beginner Joined: 09 Feb 2005 Posts: 10

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

Google