MS SQL Server Date StartOfDay EndOfDay

CREATE FUNCTION [dbo].[fnDate_EndOfDay]
(
@date datetime
)
RETURNS datetime
AS
BEGIN
return CONVERT(DATETIME, CONVERT(varchar(11), @date, 111 ) + ' 23:59:59', 111)
END

CREATE FUNCTION [dbo].[fnDate_StartOfDay]
(
@date datetime
)
RETURNS datetime
AS
BEGIN
return CONVERT(DATETIME, CONVERT(varchar(11), @date, 111 ) + ' 00:00:00', 111)
END


print dbo.fnDate_StartOfDay(getdate())
print dbo.fnDate_EndOfDay(getdate())


Jan 24 2019 12:00AM
Jan 24 2019 11:59PM