Aravindan GP
asked on
Conversion of a number field in oracle sql
Hi,
I am having a field which is a number(4) and it has values like
5000,-6000,-44,-56
I want it to be converted to
50:00
-60:00
-44:00
-56:00
Can this be done.
Please let me know.
Regards..
I am having a field which is a number(4) and it has values like
5000,-6000,-44,-56
I want it to be converted to
50:00
-60:00
-44:00
-56:00
Can this be done.
Please let me know.
Regards..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
select to_char(column,'999,999,99 9,990.00') from table
ASKER
@ bawer this won't work out.
as it will give -6000:00 , 5000:00
I need -60:00 for 6000 and 50:00 for 5000
@tosse I have many values in that table, i gave 4 values as an example..
how to change your query in that case?
as it will give -6000:00 , 5000:00
I need -60:00 for 6000 and 50:00 for 5000
@tosse I have many values in that table, i gave 4 values as an example..
how to change your query in that case?
ASKER
@ tosse I found the way from your query, thanks.
ASKER
Thank you :)