Обсуждение: need magic formula for euro conversion

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?

TIA

Cheers

Tony Grant

--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html

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