10 lines
187 B
Transact-SQL
10 lines
187 B
Transact-SQL
CREATE FUNCTION [dbo].[ToShortDateString]
|
|
(
|
|
@date datetime
|
|
)
|
|
RETURNS varchar(10)
|
|
AS
|
|
BEGIN
|
|
--RETURN DATEADD(dd, 0, DATEDIFF(dd, 0, @date))
|
|
RETURN CONVERT(VARCHAR(10), @date, 103)
|
|
END |