Date/time Calculation
Home > IT Answers > Development > Date/time Calculation
Chowdary16
5 pts.
0
Q:
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
ASKED: Apr 1 2009  11:31 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
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:

SELECT (DATEDIFF( hh , startdate , enddate ) ) as Hours_Remaining

Regards
Last Answered: Apr 4 2009  3:13 PM GMT by Alessandro.panzetta   9615 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

BrentSheets   6535 pts.  |   Apr 1 2009  12:21PM GMT

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.

 
0