Sybase Philippines

Hi to all programmers ,

I'm having a hard time computing the hours(in decimal) between two different dates (datatype for both is datetime) because the maximum allowed for time is 23:59. for example,
time in : 12/10/2007 22:00
timeout : 12/11/2007 06:30
this should output 8.30 hours

thanks.

Hi!

1) Make sure Date of TimeIn Occurs Before Date of TimeOut
2) (DaysAfter(timein, timeout) * (3600*24) + SecondsAfter(timein, timeout)) / 3600


This logic will return the seconds difference between timein timeout

PS: i made corrections from my previous post to address multiple DaysAfter

I hope this link will be helpful


http://www.experts-exchange.com/Program ... 07850.html

check this out:

Convert(numeric(4,2), datediff(mi,"TimeIn", "TimeOut")/60.00)

ex.

Convert(numeric(4,2), datediff(mi,"09:30 AM", "06:00 PM")/60.00)

returns 8.50

NOTE:
Unauthorized copy and pasting this code may result to criminal charges