---- formate un date--CREATE FUNCTION [dbo].[date103](@the_date DATETIME)RETURNS VARCHAR(10)AS BEGIN RETURN CONVERT(VARCHAR(10), @the_date, 103)END