sql server - How to get just the date part of getdate() - Stack ...

2012年8月24日 - I have a sql table that has a CreationDate field. I have getdate() in the ... If you are using SQL Server 2008 or later select convert(date, getdate()).

stackoverflow.com