Home > IT Answers > Development > Date/time Calculation
Chowdary16
5 pts.
 Date/time Calculation
DateTime
I want to calculate the Date/time in hours when the document is in status of "Work in Progress" by using starttime and endtime

Software/Hardware used:
ASKED: April 1, 2009  11:31 AM
UPDATED: April 4, 2009  3:13 PM
RELATED QUESTIONS
Answer Wiki:
I'm not sure about the language/environment you refer to but anyway many languages include datetime operations such as DATEDIFF, DATEADD, DATEPART and so on. Anyway I assume that SQL is used in this case so: <b>SELECT (DATEDIFF( hh , startdate , enddate ) ) as Hours_Remaining</b> Regards
Last Wiki Answer Submitted:  April 4, 2009  3:13 pm  by  alessandro.panzetta   9,695 pts.
All Answer Wiki Contributors:  alessandro.panzetta   9,695 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Moderator Note: Chowdary16, welcome to IT Knowledge Exchange. On future questions, please take a moment to include a meaningful tag and provide more details, such as what product or platform applies to the question. I added a tag for you but without more information, it will be difficult for other members to answer your question. You may provide more information by adding a comment below. Thanks.

BrentSheets
 6,565 pts.