20 lines
No EOL
379 B
Transact-SQL
20 lines
No EOL
379 B
Transact-SQL
IF OBJECT_ID('dbo.fnGetDokumentumDatumFormatum') IS NOT NULL BEGIN
|
|
DROP FUNCTION dbo.fnGetDokumentumDatumFormatum
|
|
END
|
|
GO
|
|
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
|
|
CREATE FUNCTION dbo.fnGetDokumentumDatumFormatum (@datum DATE)
|
|
RETURNS NVARCHAR(MAX)
|
|
BEGIN
|
|
DECLARE @value NVARCHAR(MAX)
|
|
|
|
SELECT @value =
|
|
FORMAT(@datum, 'yyyy.MM.dd.')
|
|
|
|
RETURN @value
|
|
END; |