CREATE FUNCTION [dbo].[ToShortDateString] ( @date datetime ) RETURNS varchar(10) AS BEGIN --RETURN DATEADD(dd, 0, DATEDIFF(dd, 0, @date)) RETURN CONVERT(VARCHAR(10), @date, 103) END