Get day from a datetime value : Update function « Trigger « SQL Server / T-SQL Tutorial

1. SQL Server / T-SQL Tutorial
2. Trigger
3. Update function

create FUNCTION DayOnly(@Date datetime)
   RETURNS varchar(12)
   WITH SCHEMABINDING
   AS
   BEGIN
      RETURN CONVERT(varchar(12), @Date, 101)
   END
   GO

drop FUNCTION DayOnly;
GO