so i fixed my laptop (thanks keefy), so its time for another highly entertaining thread......
can anyone help me with format masks in sql please? its really pissing me off that i don't understand fully how they affect the output in oracle (or any database software).
select to_char(0001,'009') from dual;
would return 001?
the 0's represent what, just leading zeros that are added onto the figure? and the 9's represent the width of the number?
what confuses me then is when you put decimals in.
select to_char(0011,'009.9') from dual;
why does this then return 11.0 and not 1.1?
can anyone explain this to me simply? because oracle docs tends to gloss over certain aspects when you try them out in reality.
Latest PSU headlines:
Results 1 to 1 of 1
Thread: numeric format models - sql
numeric format models - sqlGot YLOD? In the UK? I'll buy it off you.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)