Subject | how do you format currency in firebird |
---|---|
Author | dixonepperson |
Post date | 2003-08-22T20:34:22Z |
I have a select statement where some of the fields returned are
numeric(10,2). In my select statment I would like to format the
numbers as currency.
example if a value stored in the database is 234.5 I would like to
have that formatted in the result set as 234.50
I've seen it done in mssql, but not sure how to do it in Firebird
dixon
numeric(10,2). In my select statment I would like to format the
numbers as currency.
example if a value stored in the database is 234.5 I would like to
have that formatted in the result set as 234.50
I've seen it done in mssql, but not sure how to do it in Firebird
dixon