Posted by lisa.moffitt on 03/30/07 20:51

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

• Next in forum: Re: Combine multiple records into single row
• Prev in forum: Re: Combine multiple records into single row
• Thread view: Converting a date field to the month

[Reply to this message]