oracle - how to show zero on the left before decimal point when using round()? -


i used round() function show file size in byte mb.

the data following-

file_size ---------- 2463 

i used convert-

round(document.file_size / (1024*1024), 3) file_size 

now data showing this-

file_size ---------- .002 

but, want this-

file_size ---------- 0.002 

just left zero. how can have this?

try to_char(round(document.file_size / (1024*1024), 3), 990.000) file_size

more information can find here: https://asktom.oracle.com/pls/apex/f?p=100:11:0::no::p11_question_id:2739503983093


Comments

Popular posts from this blog

How has firefox/gecko HTML+CSS rendering changed in version 38? -

javascript - Complex json ng-repeat -

jquery - Cloning of rows and columns from the old table into the new with colSpan and rowSpan -