TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Jose Saiz
1.5k
260
103.2k
How to Convert numeric data type with 1 digit decimal
Jul 9 2018 6:50 PM
How to add to a numeric data type with 1 digit decimal a zero.
For Instance
Assuming that I got a result from a calculation 7.7 which means 7.07, how to add the leading zero or how to convert to a 2 decimal points
The ROUND() rounds it to 7.70 and or 8.0 and what I am looking for to be 2 decimal points with the leading zero, in other word the result should be 7.07
I will really appriciates for sample code that converts from 7.7 to 7.07
Thanks
Jose
Reply
Answers (
5
)
sql procedure for select and insert at same time
carry forward balance as opening/calculate balance in ledger