One in one out

Create a function named SumRideHrsSingleDay() which returns the total ride time in hours for the @DateParm parameter passed.

Cet exercice fait partie du cours

Writing Functions and Stored Procedures in SQL Server

Afficher le cours

Instructions

Define input parameter of type date - @DateParm and a return data type of numeric.
Use BEGIN/END keywords.
In your SELECT statement, SUM the difference between the StartDate and EndDate of the transactions that have the same StartDate value as the parameter passed.
Use CAST to compare the date portion of StartDate to the @DateParm.

Exercice interactif pratique

Essayez cet exercice en complétant cet exemple de 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
___

Modifier et exécuter le code