ASPForums.Net RSS Feedhttp://www.aspforums.net/Handlers/RSS.ashxLatest additions to the content that appears on ASPForums.Net(c) 2019 www.aspforums.com. All rights reserved.Remove Hour minute second (Time) from DateTime in SQL Server<p>Hi&nbsp;paulrajmca,</p> <p>Check this example.</p> <p><strong><span style="text-decoration: underline;">SQL</span></strong></p> <pre class="brush: sql">-- In SQL Server 2005 and below. SELECT CONVERT(VARCHAR(10), GETDATE(), 120) -- In SQL Server 2008 and Above. SELECT CONVERT(DATE, GETDATE()) </pre> <p><strong><span style="text-decoration: underline;">Output</span></strong></p> <p>2019-06-20</p>https://www.aspforums.net:443/Threads/941083/Remove-Hour-minute-second-Time-from-DateTime-in-SQL-Server/https://www.aspforums.net:443/Threads/941083/Remove-Hour-minute-second-Time-from-DateTime-in-SQL-Server/Thu, 20 Jun 2019 04:31:07 GMT