troubleshooting Question

SQL scrip to extract decimal portion from a value

Avatar of jana
janaFlag for United States of America asked on
DatabasesCrystal ReportsSQL
16 Comments6 Solutions702 ViewsLast Modified:
We need to extract the decimal value from a result; that is where the result is 2.4574, I want to have the decimal value of work with.   We need this with any result; for example:

result of 5.2584, we need .2584
result of 11.3582, we need .3582
result of   6.9884, we need .9884
result of   0.635, we need .635

In essence, in order to give more infor of what's needed, we need to work with the excess of period of years.  For example:

subtract 02/01/2008 from 07/07/2010, and you get 887 days, divide that by 365, you get 2.430136986.

We need to extract and work with the decimal portion of .430136986.

Join our community to see this answer!
Unlock 6 Answers and 16 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 6 Answers and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros