tag:blogger.com,1999:blog-6101006543641561368.post6999121893767505217..comments2024-01-19T11:43:10.765-06:00Comments on sqlfingers.com: DATEPART returns three character month names, date and year.sqlfingershttp://www.blogger.com/profile/17197470820730005093noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6101006543641561368.post-40789989462371005402017-07-31T06:51:26.998-05:002017-07-31T06:51:26.998-05:00ALSO
SELECT FORMAT([Date],'MMM') AS [Sho...ALSO <br /><br />SELECT FORMAT([Date],'MMM') AS [Short Month Name]Ankurhttps://www.blogger.com/profile/05656724984746288360noreply@blogger.comtag:blogger.com,1999:blog-6101006543641561368.post-12270053069425242622013-03-07T09:31:48.654-06:002013-03-07T09:31:48.654-06:00The same can be done like this:
SELECT Date = LEFT...The same can be done like this:<br />SELECT Date = LEFT(DATENAME( m, GETDATE()),3) + ' ' + DATENAME(dd,GETDATE()) + ', ' + DATENAME(yyyy,GETDATE())<br />Dutchhttps://www.blogger.com/profile/14099502390999999133noreply@blogger.com