SELECT
    AutoShipItems.CustomerID,AutoShipItems.NextOrderDate,
    Customer.FirstName,Customer.LastName, Customer.EmailAddress
FROM
    AutoShipItems
        INNER JOIN    Customer ON
            AutoShipItems.CustomerID =Customer.CustomerID
WHERE
    (AutoShipItems.NextOrderDate <= GETDATE())
GROUP BY
    AutoShipItems.CustomerID, AutoShipItems.NextOrderDate,
    Customer.FirstName, Customer.LastName,
    Customer.EmailAddress
ORDER BY
    AutoShipItems.NextOrderDate

cast(floor(cast(AutoShipItems.NextOrderDate as float)) as datetime)

create function [dbo].[xfn_TrimTimeFromDateTime]
(
    @date as datetime
)
returns datetime with schemabinding as
begin
    --- Convert to a float, and get the integer that represents it.
    --- And then convert back to datetime.
    return cast(floor(cast(@date as float)) as datetime)
end

GROUP BY
    AutoShipItems.CustomerID,
    dbo.xfn_TrimTimeFromDateTime(AutoShipItems.NextOrderDate),
    Customer.FirstName, Customer.LastName, Customer.EmailAddress

cast (x as date)

year(x)
month(x)
day(x)

select convert(datetime, convert(varchar(10), getdate(), 112))

convert(date, @x)

cast(@x as date)

CREATE FUNCTION [dbo].[fn_GetDateOnly]  ( @pInputDate    DATETIME )
RETURNS DATETIME
BEGIN

    RETURN CAST(CONVERT(VARCHAR(10), @pInputDate, 111) AS DATETIME)

END

SELECT    AutoShipItems.CustomerID, convert(nvarchar(10), AutoShipItems.NextOrderDate, 110) as NextOrderDate ,Customer.FirstName,Customer.LastName,
                     Customer.EmailAddress
FROM        AutoShipItems INNER JOIN
                     Customer ON AutoShipItems.CustomerID =Customer.CustomerID
WHERE     (AutoShipItems.NextOrderDate <= GETDATE())
GROUP BY AutoShipItems.CustomerID, convert(nvarchar(10), AutoShipItems.NextOrderDate, 110) , Customer.FirstName, Customer.LastName,
                     Customer.EmailAddress
ORDER BY AutoShipItems.NextOrderDate

CAST(datetime - 0.5 AS int)

CAST(CAST(datetime AS float) AS int)