Jeff S
asked on
SQL 2005 DateFormatting / Output to custom value
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
Example - DOB = 01/15/1960
I want this in my output
'DOBMonth' = 01
'DOBDay' = 15
'DOBYear' = 1960
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THANKS!!
You're welcome! Thanks for the points and see you soon!
select DAY(dob), MONTH(dob ), YEAR(dob )
from yourtable