how to get decimal part in sql server

Jak
Jak
Member
858 Points
132 Posts

how to get decimal part in sql server?

Views: 8884
Total Answered: 1
Total Marked As Answer: 1
Posted On: 16-Feb-2015 12:10

Share:   fb twitter linkedin
Answers
NiceOne Team
NiceOne...
Editor
1382 Points
14 Posts
         

Hi,

You can use Floor Method as:

SELECT Value - FLOOR(Value)
SELECT 100.123 - FLOOR(100.123)
Posted On: 16-Feb-2015 23:49
 Log In to Chat