<div>
If you want to see the date and time, then why use the CONVERT function at all?
</div>


If you want to see the date and time, then why use the CONVERT function at all?

<div>
You can use CONVERT(varchar(20),DateSu<wbr />bmitted,0)<wbr />. &nbsp;Look at the table in BOL to see what all the convert options do.<br />

</div>


You can use CONVERT(varchar(20),DateSubmitted,0).  Look at the table in BOL to see what all the convert options do.


<div>
I need to use such as 08/15/2011 on the date part.. shows me Aug 15 2011
</div>


I need to use such as 08/15/2011 on the date part.. shows me Aug 15 2011

<div>
Then you need to combine two:<br />
<br />
SELECT convert(varchar(8),DateSub<wbr />mitted,101<wbr />) + ' ' + convert(varchar(5),DateSub<wbr />mitted,108<wbr />)
</div>


Then you need to combine two:

SELECT convert(varchar(8),DateSubmitted,101) + ' ' + convert(varchar(5),DateSubmitted,108)

<div>
still not right... it shows me as 08/15/20
</div>


still not right... it shows me as 08/15/20

<div>
still need a see AM, PM also :)
</div>


<div>
thank you ewangoya! it works.. Ok, how should I give points now? :) 
</div>


thank you ewangoya! it works.. Ok, how should I give points now? :)

<div>
<br />
At your discretion, you can split or award all points according to the relevance and correctness of the solution<br />

</div>



At your discretion, you can split or award all points according to the relevance and correctness of the solution


<div>
<div class="content wysiwyg-content">
convert(varchar, dateSubmitted, 110) as dateSubmitted just gives me date a 08/15/2011 format and I want to also see time beside the date how to do that.. tsql
</div>
</div>


convert(varchar, dateSubmitted, 110) as dateSubmitted just gives me date a 08/15/2011 format and I want to also see time beside the date how to do that.. tsql

datetime format

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.