Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!
This is from 12:00 AM to 3:00 AM so i would expect the total to be 3 Hours.
2015-02-19 00:00:00.000 2015-02-19 00:30:00.000 2015-02-19 01:00:00.000 2015-02-19 01:30:00.000 2015-02-19 02:00:00.000 2015-02-19 02:30:00.000 2015-02-19 03:00:00.000
select datepart(hour, cast(FullDatetime as time)) as totHours from myTable where id in (1, 2, 3,4,5, 7)
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Running total between 2 sql tables in Sql||6||44|
|Tempdb Contention - SQL SERVER||10||37|
|CAST issue with SQL 2000||15||42|
|File attachment in the SQL Database from application||10||39|
Join the community of 500,000 technology professionals and ask your questions.