SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

CREATE FUNCTION StdDTNotatieStr (@STRDT as char(30))
RETURNS char(19)
AS
BEGIN
  DECLARE @StdDTNotatieStr char(19)
  DECLARE @tmpStr char(19)
  DECLARE @jaar char(4)
  DECLARE @maand char(2)
  DECLARE @dag char(2)
  DECLARE @uur char(2)
  DECLARE @minuut char(2)
  DECLARE @seconde char(2)

  set @jaar = substring(@STRDT,1,4)
  set @maand = substring(@STRDT,5,2)
  set @dag = substring(@STRDT,7,2)
  set @uur = substring(@STRDT,9,2)
  set @minuut = substring(@STRDT,11,2)
  set @seconde = substring(@STRDT,13,2)

  set @StdDTNotatieStr = @dag + '-' + @maand + '-' + @jaar + ' ' + @uur + ':' + @minuut + ':' + @seconde


  RETURN(@StdDTNotatieStr)
END

GO