Question
April 6, 2007 at 10:10 AM
tytyu67567

DATEDIFF FUNCTION

by tytyu67567 . Updated 19 years, 6 months ago

Hi,

Im a developer. I have a question on the DATEDIFF function, hope you can help me out. Im using DATEDIFF function, I know that it will result in integer value. But, I need the result in decimals.

For example :

STARTDATE ENDATE RESULT
8/27/2003 9/2/1976 26.11
9/1/2003 1/6/2000 3.8

CAN YOU PLEASE HELP ME ?

THANKS IN ADVANCE

This discussion is locked

All Comments