<div>
declare @date datetime<br />
set @date = '02FEB1951'<br />
<br />
select @date as [Original Date]<br />
, convert(varchar(10), @date, 106) as [dd mon yy]<br />
, replace(convert(varchar(10<wbr />), @date, 6), ' ', '') as [Requested format]
</div>


declare @date datetime
set @date = '02FEB1951'

select @date as [Original Date]
, convert(varchar(10), @date, 106) as [dd mon yy]
, replace(convert(varchar(10), @date, 6), ' ', '') as [Requested format]

<div>
You can use the following in your code<br />
<br />
SELECT REPLACE(CONVERT(VARCHAR(11<wbr />), &lt;fieldName&gt;,106), ' ', '') AS [DDMonYYYY]
</div>


You can use the following in your code

SELECT REPLACE(CONVERT(VARCHAR(11), <fieldName>,106), ' ', '') AS [DDMonYYYY]

<div>
<div class="content wysiwyg-content">
I am reading a table using PROC SQL from a SQL Server database. &nbsp;The DOB field is coming in datetime format. &nbsp;<br />
<br />
I would like to convert 02FEB1951:00:00:00.000 &nbsp; &nbsp;to &nbsp; &nbsp; 02FEB1951
</div>
</div>


I am reading a table using PROC SQL from a SQL Server database.  The DOB field is coming in datetime format.  

I would like to convert 02FEB1951:00:00:00.000    to     02FEB1951

Converting a date time date to ddmmyyyyformat

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.