0

Hi to all,
i created following table
-------------------------------------

create table employee(name varchar(20), dob datetime)
-------------------------------------

I want to extract names of all months from 'dob'. for that i wrote following query
-------------------------------------
select datepart(month, dob) from employee
--------------------------------------
it works and shows all months but in number format,
i want to display all months in character format. i.e. january, february, march, ...
How can I do it?

Thanks & regards,
Pooja.

2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by Momerath
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.