ASPForums.Net RSS Feed additions to the content that appears on ASPForums.Net(c) 2019 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>, 20 Jun 2019 04:31:07 GMT