<div>
<div class="content wysiwyg-content">
 I can't seem to figure out what I am doing wrong. I have a table that contains a field in a smalldatetime format. I am trying to get sql to populate a text file. I want the smalldatetime field out of sql in the mm/dd/yy format. I am using a simple select statement. But all I get back is the standard sql date display in query analyzer. Here is the code and an example of the output.<br />
<br />
Select <br />
Convert(smalldatetime,Prod<wbr />_Orig_Pub_<wbr />Dt,1) AS Prod_Orig_Pub_Dt<br />
FROM tbl_Product_FTP <br />
<br />
This is what the query window displays....<br />
<br />
2004-05-06 00:00:00<br />

</div>
</div>


 I can't seem to figure out what I am doing wrong. I have a table that contains a field in a smalldatetime format. I am trying to get sql to populate a text file. I want the smalldatetime field out of sql in the mm/dd/yy format. I am using a simple select statement. But all I get back is the standard sql date display in query analyzer. Here is the code and an example of the output.

Select 
Convert(smalldatetime,Prod_Orig_Pub_Dt,1) AS Prod_Orig_Pub_Dt
FROM tbl_Product_FTP 

This is what the query window displays....

2004-05-06 00:00:00


Problem Converting Smalldatetime to mm/dd/yy in SQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.