Link to home
Start Free TrialLog in
Avatar of zimmer9
zimmer9Flag for United States of America

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 ...
ASKER CERTIFIED SOLUTION
Avatar of _agx_
_agx_
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial