听雨

专,静,谦,筹,悟,慎,透,恒

:: :: ::

Get Date information with a datetime var

Posted on 2008-05-22 16:18 听雨阅读(96) 评论(0) 收藏举报

--Function:Get Date with a datetime

--Author: Benjamin Zhou

--2008-05-22

Declare @Date datetime

Set @Date=getdate()

select DATEADD(day, DATEDIFF(day,0,@date), 0)

刷新页面返回顶部