One in one out
Create a function named SumRideHrsSingleDay()
which returns the total ride time in hours for the @DateParm
parameter passed.
This exercise is part of the course
Writing Functions and Stored Procedures in SQL Server
Exercise instructions
- Define input parameter of type
date
-@DateParm
and a return data type ofnumeric
. - Use
BEGIN
/END
keywords. - In your
SELECT
statement,SUM
the difference between theStartDate
andEndDate
of the transactions that have the sameStartDate
value as the parameter passed. - Use
CAST
to compare thedate
portion ofStartDate
to the@DateParm
.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Create SumRideHrsSingleDay
___ ___ SumRideHrsSingleDay (___ date)
-- Specify return data type
___ ___
AS
-- Begin
___
RETURN
-- Add the difference between StartDate and EndDate
(SELECT SUM(DATEDIFF(second, StartDate, EndDate))/3600
FROM CapitalBikeShare
-- Only include transactions where StartDate = @DateParm
WHERE ___(StartDate AS ___) = ___)
-- End
___