<div>
Not sure what you mean. &nbsp;Can you give an example of what you are wanting to get.<br />
<br />
BTW, what DB are you using? SQL Server? Which version?
</div>


Not sure what you mean.  Can you give an example of what you are wanting to get.

BTW, what DB are you using? SQL Server? Which version?

<div>
SQL Server 2000 <br />
<br />
The code as is displays: &nbsp;2008-10-20 00:00:00.000<br />
I want it to display as: 2008-10-20 
</div>


SQL Server 2000

The code as is displays:  2008-10-20 00:00:00.000
I want it to display as: 2008-10-20

<div>
<div class="content wysiwyg-content">
Could someone help me display the below formula as a date only:<br />
<br />
CONVERT(varchar(10), getdate() - 4, 101) <br />
<br />
Thanks a bunch!!<br />
<br />

</div>
</div>


Could someone help me display the below formula as a date only:

CONVERT(varchar(10), getdate() - 4, 101) 

Thanks a bunch!!



How to convert datetime to date

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.