kalender.bomonth.sql 240 B

123456789101112131415161718
  1. SET QUOTED_IDENTIFIER ON
  2. GO
  3. SET ANSI_NULLS ON
  4. GO
  5. CREATE FUNCTION [kalender].[bomonth] (@Datum AS DATE)
  6. RETURNS DATE
  7. AS
  8. BEGIN
  9. RETURN DATEADD(dd, 1 - Day(@Datum), @Datum)
  10. END
  11. GO
  12. SET QUOTED_IDENTIFIER OFF
  13. GO
  14. SET ANSI_NULLS OFF
  15. GO
  16. GO