|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
How to set the length of display
if the result show on select statement is 24.67899 how can i make it just show 24.67 ?
|
|
#2
|
|||
|
|||
|
select cast(FIELDNAME AS numeric(15,2))
Replace 15 with whatever is appropriate for your field. Clive |
|
#3
|
||||
|
||||
|
Or try round but I think you need to install some udf to have it
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins |
|
#4
|
|||
|
|||
|
Quote:
I tried ROUND first but I received a SQL error. Clive |
|
#5
|
|||
|
|||
|
ya round couldn't work.......by the way thak u guys...
|
![]() |
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > How to set the length of display |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|