Posted by Erland Sommarskog on 03/30/07 21:34

(lisa.moffitt@gmail.com) writes:
> How can I create a field in a view that takes a date field and
> converts it to a month?
> For instance, if I have a field called "CreatedOn" with a date of
> '2/22/2007', how can I create another field called "Month" that will
> say "February"? Is there a built-in SQL function that does this (like
> using CONVERT) or do I need to write my own?

Look up datename in Books Online.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Allowing users to truncate log file
• Prev in forum: Re: Run query based on values in another table
• Thread view: Re: Converting a date field to the month

[Reply to this message]