On 05 Jun 2002 17:14:10 +0200, tony <tony@animaproductions.com> wrote:
>Hello,
>
>Does anyone out there in Euroland have the magic formula that will let
>me convert a decimal(12,2) column to another decimal(12,2) column with
>automatic rounding up or down to comply with the EURO conversion rules?
Tony,
SELECT e, (e * 13.7603::decimal(12,4))::decimal(12,2) AS ats
FROM eur;
e | ats
------+-------
1.00 | 13.76
0.10 | 1.38
This might solve part of your problem. Hope you get the direction.
Servus
Manfred