Thursday, August 1, 2013

get month name from date part

To get the month name from a given date, u should use the following query block

Query
SELECT DATENAME(MONTH, GETDATE())

Result
August

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)