MS Access to SQL server 2008

Question

Hi All - I am entirely new to SQL Server - 
 can anyone please help me in converting the following 
from access to SQL Server 2008

in ACCESS
=sum([mytable]![end]-[mytable]![start]) * 24 + 
sum([mytable]![end]-[mytable]![start]) *8

start - data type in SQL Server 2008 is dateime values look 
like 2012-01-25 15:22:48.000

end - data type in SQL Server 2008 is datetime values 
look like 2012-01-25 15:18:40.437
I basically need the total number of hours and mins only 
something like 22:10 (twenty two hours and 10 mins)

thank you in advance for your help and time

Answer 1

Hi All - can anyone please help me on this - i am still looking into previou posts

Answer 2

Hi SQLServerRaj,

Since this forum is for SQL Server, and not all of the communities know the access query. So, could you post the sample table and describe your requirement for the query?

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 3

Try using DATEDIFF function to get the difference in seconds (assuming your two dates are not too far apart) and then do a basic math to get days, hours, minutes from the seconds value.

See also http://bytes.com/topic/sql-server/answers/143394-convert-seconds-hours-minutes-seconds

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 4

The following article is on datetime conversion & date and time functions:

http://www.sqlusa.com/bestpractices/datetimeconversion/

If you convert datetime to string, you can truncate the seconds and milliseconds with the LEFT() or other string functions.

---

Kalman Toth SQL SERVER 2012 & BI TRAINING
New Book: Beginner Database Design & SQL Programming Using Microsoft SQL Server 2012