- --SQL Server 2005
- convert(varchar(10),getdate(),120)
- convert(varchar(10),getdate(),23)
- --SQL Server 2008
- SELECT CAST(GetDate() as DATE)
- SELECT CONVERT(DATE,GetDate())
- --该片段来自于http://www.codesnippet.cn/detail/220420132948.html
来源: http://www.codesnippet.cn/detail/220420132948.html