sql日期格式

create FUNCTION [dbo].[DateValue] (@time smalldatetime) 
returns date as
begin
RETURN CONVERT(smalldatetime, CONVERT(char(8), @time, 112), 112) --2005
end

 

 

SELECT GETDATE()

  select dbo.datevalue(GETDATE())

 

-----------------------
2010-08-03 09:41:22.900

(1 row(s) affected)

----------
2010-08-03

(1 row(s) affected)