Select a date without time (SQL Server (+)

2018-07-03 21:10:36

This question already has an answer here:

How to return only the Date from a SQL Server DateTime datatype 37 answers

On SQL Server 2008 and higher, you should convert to date:

SELECT CONVERT(date, (DATEADD(year, -1, GETDATE())))

On older versions, you can do the following:

SELECT DATEADD(dd, 0, DATEDIFF(dd, 0, DATEADD(year, -1, GETDATE())))

链接地址: http://www.djcxy.com/p/94382.html