<div>
Detailed with examples follow: <a href="http://www.sqlusa.com/bestpractices/datetimeconversion/" rel="ugc">http://www.sqlusa.com/bestpractices/datetimeconversion/</a><br />

</div>


Detailed with examples follow: http://www.sqlusa.com/bestpractices/datetimeconversion/ [http://www.sqlusa.com/bestpractices/datetimeconversion/]


<div>
I tried :<br />
<br />
string strRenewalDateSQL = &quot;SELECT CONVERT(varchar, &nbsp;LastPaidDate, 101) AS LastPaidDate &quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; strRenewalDateSQL += &quot;FROM Subscriptions &nbsp;WHERE UserID = '&quot; + strUserID + &quot;'&quot;;<br />
<br />
This does not return LastPaidDate as a string.<br />
<br />
Please help. I found it difficult to try several of the many examples.<br />
<br />
Please correct the syntax.<br />
<br />
Thanks,
</div>


I tried :

string strRenewalDateSQL = "SELECT CONVERT(varchar,  LastPaidDate, 101) AS LastPaidDate ";
            strRenewalDateSQL += "FROM Subscriptions  WHERE UserID = '" + strUserID + "'";

This does not return LastPaidDate as a string.

Please help. I found it difficult to try several of the many examples.

Please correct the syntax.

Thanks,

<div>
strUserID is not a valid user.<br />
<br />
My code returned none as expected.<br />
<br />
All is OK now.<br />
<br />
Thanks,
</div>


strUserID is not a valid user.

My code returned none as expected.

All is OK now.

Thanks,

<div>
<div class="content wysiwyg-content">
I need to return a datetime collumn value as a string.<br />
<br />
The following is not correct.<br />
<br />
string strRenewalDateSQL = &quot;SELECT Convert(DateTime,DateAdd(m<wbr />onth,1,Las<wbr />tPaidDate)<wbr />,101) AS RenewalDate &quot;;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; strRenewalDateSQL += &quot;FROM Subscriptions &nbsp;WHERE UserID = '&quot; + strUserID + &quot;'&quot;;<br />
<br />
What is the correct syntax?
</div>
</div>


I need to return a datetime collumn value as a string.

The following is not correct.

string strRenewalDateSQL = "SELECT Convert(DateTime,DateAdd(month,1,LastPaidDate),101) AS RenewalDate ";
            strRenewalDateSQL += "FROM Subscriptions  WHERE UserID = '" + strUserID + "'";

What is the correct syntax?

Use SQL to return date as a string

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.