May 31, 2005 at 2:19 am
Can anyone tell me how to get a short month from a date e.g. JAN, FEB etc
Thanks
May 31, 2005 at 2:29 am
I would consider this a task for your presentational layer. anyway, does this help?
select left(convert(varchar,<your column >,100),3)
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
May 31, 2005 at 2:31 am
Thanks Frank
May 31, 2005 at 2:34 am
Now if this has helped, and you're a lazytyper, this should also work
select left(datename(month, < your column > ),3)
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply