<div>
or <br />
<br />
select DAY(dob), MONTH(dob ), YEAR(dob )<br />
from yourtable 
</div>


or

select DAY(dob), MONTH(dob ), YEAR(dob )
from yourtable

<div>
You're welcome! Thanks for the points and see you soon!
</div>


You're welcome! Thanks for the points and see you soon!

<div>
<div class="content wysiwyg-content">
I would like to take my field PatientProfile.Birthdate and make it 3 fields. <br />
<br />
Example - DOB = 01/15/1960<br />
<br />
I want this in my output<br />
<br />
'DOBMonth' = 01<br />
'DOBDay' = 15<br />
'DOBYear' = 1960<br />
<br />

</div>
</div>


I would like to take my field PatientProfile.Birthdate and make it 3 fields. 

Example - DOB = 01/15/1960

I want this in my output

'DOBMonth' = 01
'DOBDay' = 15
'DOBYear' = 1960



SQL 2005 DateFormatting / Output to custom value

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.