| Subject | Re: [firebird-support] formating a numeric column |
|---|---|
| Author | Helen Borrie |
| Post date | 2008-09-26T00:08:28Z |
At 04:51 26/09/2008, you wrote:
./heLen
>[FB2.1]Yes. It's called a "double cast".
>Hi I have a column defined as numeric(18,3) and I want to cast it to char but
>with 2 decimal places. I'm doing this and it works fine, but I'm curious if this
>is the "proper" way to do it...
>
>SELECT
> CAST(CAST(PAGOS_EFECTIVO.IMPORTE AS NUMERIC(18,2)) AS VARCHAR(20))
./heLen