<div>
SELECT convert(varchar, getdate(), 103) – dd/mm/yyyy<br />
<br />
Here are more formats that can help u more<br />
<br />
<a href="http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/" rel="ugc">http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/</a>
</div>


SELECT convert(varchar, getdate(), 103) – dd/mm/yyyy

Here are more formats that can help u more

http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/ [http://anubhavg.wordpress.com/2009/06/11/how-to-format-datetime-date-in-sql-server-2005/]

<div>
Please check the following:<br />
<a href="http://weblogs.sqlteam.com/jeffs/archive/2007/10/31/sql-server-2005-date-time-only-data-types.aspx" rel="ugc">http://weblogs.sqlteam.com/jeffs/archive/2007/10/31/sql-server-2005-date-time-only-data-types.aspx</a>
</div>


Please check the following:
http://weblogs.sqlteam.com/jeffs/archive/2007/10/31/sql-server-2005-date-time-only-data-types.aspx [http://weblogs.sqlteam.com/jeffs/archive/2007/10/31/sql-server-2005-date-time-only-data-types.aspx]

<div>
If you are using SQLServer 2008 then it has Just Date datatype. So you can use that...
</div>


If you are using SQLServer 2008 then it has Just Date datatype. So you can use that...

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have a SQL table in my ASP project as shown in the image below. I am a little concerned<br />
about the [Start date] and [Start time] column. If I query the table the [Start date] comes up with<br />
the date and the time. How do I change it so it just shows the date <a href="https://filedb.experts-exchange.com/incoming/2011/03_w10/414912/image.jpg" target="_blank" title="table (33 KB)"><img alt="table" class="file-block lazyload" style="max-width: 384px;" data-src="https://filedb.experts-exchange.com/incoming/2011/03_w10/414912/image.jpg" /></a>
</div>
</div>


image.jpg

Hi

I have a SQL table in my ASP project as shown in the image below. I am a little concerned
about the [Start date] and [Start time] column. If I query the table the [Start date] comes up with
the date and the time. How do I change it so it just shows the date 

ASP.net SQL table data types

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications