MSSQL 2008: Get month (Jan,Feb..) from datetime
HI!
How do I format/convert the datetime to only return a string with the month? Jan,Feb, ...
How do I format/convert the datetime to only return a string with the month? Jan,Feb, ...
SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
pritamdutt
Checkout : select DATENAME(m,GETDATE())
ASKER
so to get the 3 char?
CONVERT(Varchar(3), datename(month, month(getdate())))
CONVERT(Varchar(3), datename(month, month(getdate())))
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
ops..
select CONVERT(Varchar(3), datename(month, getdate()))
select CONVERT(Varchar(3), datename(month, getdate()))
You already have the answer from Eval and Me for your last question...
Please take a look
Please take a look
ASKER
Thx guys!! :)