Trigger MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Trigger
  4. Get day from a datetime value
create FUNCTION DayOnly(@Date datetime)
   RETURNS varchar(12)
   WITH SCHEMABINDING
   AS
   BEGIN
      RETURN CONVERT(varchar(12), @Date, 101)
   END
   GO
drop FUNCTION DayOnly;
GO