only select date part from datetime - SQL Snipplr Social Repository

Revision: 31186

at August 31, 2010 21:55 by g8rpal

Initial Code

SELECT CONVERT(VARCHAR(10),GETDATE(),111)

Initial URL

http://blog.sqlauthority.com/2007/06/10/sql-server-retrieve-select-only-date-part-from-datetime-best-practice/

Initial Description

Initial Title

only select date part from datetime

Initial Tags

sql, date, simple

Initial Language

SQL