SELECT CONVERT(char(10), GetDate(),126)
Limiting the size of the varchar chops of the hour portion that you don’t want.
More Related Contents:
- Comma separated results in SQL
- T-SQL stored procedure that accepts multiple Id values
- Understanding PIVOT function in T-SQL
- How do I escape a percentage sign in T-SQL?
- Using RegEx in SQL Server
- Why use a READ UNCOMMITTED isolation level?
- Replace duplicate spaces with a single space in T-SQL
- How do you count the number of occurrences of a certain substring in a SQL varchar?
- SQL Server: Isolation level leaks across pooled connections
- What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
- How do I use the CONCAT function in SQL Server 2008 R2?
- How can sanitation that escapes single quotes be defeated by SQL injection in SQL Server?
- How do I exclude Weekend days in a SQL Server query?
- Scheduled run of stored procedure on SQL server
- EXEC sp_executesql with multiple parameters
- Preserving ORDER BY in SELECT INTO
- Select / Insert version of an Upsert: is there a design pattern for high concurrency?
- Can you call a webservice from TSQL code?
- How to add custom attributes to SQL connection string?
- Multiple Column Pivot in T-SQL
- Convert decimal time to hours and minutes
- Joining multiple tables returns NULL value
- Which join syntax is better?
- Compute MD5 hash of a UTF8 string
- LPAD in SQL Server 2008
- SQL Query Where Column = ” returning Emoji characters 🎃 and 🍰
- How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
- How do I remove non-breaking spaces from a column in SQL server?
- Is there an “IF EXISTS” test for a linked server?
- SQL Server stored procedure return code oddity