Converting a date field to the month

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lisa.moffitt@gmail.com - 30 Mar 2007 21:51 GMT

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?

Thanks!
Lisa

Reply to this Message

Erland Sommarskog - 30 Mar 2007 22:34 GMT

> 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.

Signature

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

Reply to this Message