SQLServerPedia

Q: What is the syntax for retreiving date from dob column in a specified format, for example “2nd of july 1985″?

James Delve says: Here is an example:

I have chosen to represent the Hire_date from pubs..authors as a DOB column, but you get the picture.

use pubs
go
select cast(datepart(DD, hire_date) as varchar(10)) + ‘ ‘ + ‘of’ + ‘ ‘ + cast(datename([Month],Hire_date) as varchar(12))
+ ‘ ‘ + cast(Datepart(YYYY, Hire_date) as varchar(10))
as ‘DOB’
from pubs..employee