[sql-server] How to get just the date part of getdate()?

SELECT CAST(FLOOR(CAST(GETDATE() AS float)) as datetime)

SELECT CONVERT(datetime,FLOOR(CONVERT(float,GETDATE())))

Examples related to sql-server

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Count the Number of Tables in a SQL Server Database • Visual Studio 2017 does not have Business Intelligence Integration Services/Projects • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database • How to create temp table using Create statement in SQL Server? • SQL Query Where Date = Today Minus 7 Days • How do I pass a list as a parameter in a stored procedure? • SQL Server date format yyyymmdd

Examples related to tsql

• Passing multiple values for same variable in stored procedure • Count the Number of Tables in a SQL Server Database • Change Date Format(DD/MM/YYYY) in SQL SELECT Statement • Stored procedure with default parameters • Format number as percent in MS SQL Server • EXEC sp_executesql with multiple parameters • SQL Server after update trigger • How to compare datetime with only date in SQL Server • Text was truncated or one or more characters had no match in the target code page including the primary key in an unpivot • Printing integer variable and string on same line in SQL