Subject | formatting numbers |
---|---|
Author | davidallan99 |
Post date | 2004-06-22T09:55:47Z |
Hello
I am developing an app using Firebird 1.5, delphi, dbexpress and
intraweb. This is probably a very easy problem to fix, but how do I
format numbers with 2 decimal places showing, eg 2.50 shows as 2.5 in
my clientdatasets or using ISQL. In ORACLE there are various functions
to format fields such as to_char, to format numbers and dates. Is
there anything similar in Firebird. Or is there a doc somewhere that
lists all the functions?
Thanks for any help
David
I am developing an app using Firebird 1.5, delphi, dbexpress and
intraweb. This is probably a very easy problem to fix, but how do I
format numbers with 2 decimal places showing, eg 2.50 shows as 2.5 in
my clientdatasets or using ISQL. In ORACLE there are various functions
to format fields such as to_char, to format numbers and dates. Is
there anything similar in Firebird. Or is there a doc somewhere that
lists all the functions?
Thanks for any help
David