For SQL Server 2008:
Convert(date, getdate())
Please refer to https://learn.microsoft.com/en-us/sql/t-sql/functions/getdate-transact-sql
More Related Contents:
- Insert an image in a column of a table that already has 5 columns
- Get top 1 row of each group
- Referring to a Column Alias in a WHERE Clause
- Convert Month Number to Month Name Function in SQL
- How to avoid the “divide by zero” error in SQL?
- SET versus SELECT when assigning variables?
- Is there any difference between IS NULL and =NULL
- Generate a resultset of incrementing dates in TSQL
- Real life example, when to use OUTER / CROSS APPLY in SQL
- Getting result of dynamic SQL into a variable for sql-server
- How to get difference between two rows for a column field?
- Better techniques for trimming leading zeros in SQL Server?
- How to print VARCHAR(MAX) using Print Statement?
- SQL statement to select all rows from previous day
- What’s the best way to select the minimum value from several columns?
- Splitting delimited values in a SQL column into multiple rows
- varbinary to string on SQL Server
- SQL : in clause in stored procedure:how to pass values
- How to insert a blob into a database using sql server management studio
- SQL GROUP BY CASE statement with aggregate function
- separate comma separated values and store in table in sql server
- Best way to do nested case statement logic in SQL Server
- SQL Server 2005 ROW_NUMBER() without ORDER BY
- Can an INNER JOIN offer better performance than EXISTS
- How to check which locks are held on a table
- Execution sequence of Group By, Having and Where clause in SQL Server?
- SQL Server 2005 – Export table programmatically (run a .sql file to rebuild it)
- SQL Sort Order with Null values last
- Insert all values of a table into another table in SQL
- When to use EXCEPT as opposed to NOT EXISTS in Transact SQL?