zimmer9
asked on
Is there a way using SQL Server 2008 to display a varchar(10) value as Month Name followed by year [08/03/2017 -> August 2017] if the value is stored in format MM/DD/YYYY ?
I use SQL Server 2008.
If I want to write a SELECT statement to display a field that is stored as VARCHAR(10) in format MM/DD/YYYY, is there a way to write a SELECT statement that displays this field as "Month Name" followed by a space and then followed by the "YYYY" value?
For example:
dtCreated (field name)
---------------
08/03/2009 (value) convert to display as August 2009
06/05/2005 (value) convert to display as June 2009
SELECT dtCreated ...
If I want to write a SELECT statement to display a field that is stored as VARCHAR(10) in format MM/DD/YYYY, is there a way to write a SELECT statement that displays this field as "Month Name" followed by a space and then followed by the "YYYY" value?
For example:
dtCreated (field name)
---------------
08/03/2009 (value) convert to display as August 2009
06/05/2005 (value) convert to display as June 2009
SELECT dtCreated ...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.