using datename function for name of month,day

Posted on May 14, 2008. Filed under: Sql Server |

 

select DATENAME(w, GETDATE()) AS ‘ Day Name’

day name

———

Wednesday
SELECT DATENAME(m, GETDATE()) AS ‘ month Name’
month name

———

may

 

 

 

Make a Comment

Make A Comment: ( None so far )

blockquote and a tags work here.

    About

    Hi,I am Suresh Sharma(MCP) from Gorakhpur , UP, India.I have work on .net technology from 2 years. Key skills-Asp.net 2.0,3.5, Sql 2005,2000. Ajax.net 1.1,C#.net

    RSS

    Subscribe Via RSS

    • Subscribe with Bloglines
    • Add your feed to Newsburst from CNET News.com
    • Subscribe in Google Reader
    • Add to My Yahoo!
    • Subscribe in NewsGator Online
    • The latest comments to all posts in RSS
    • Subscribe in Rojo

    Meta

Liked it here?
Why not try sites on the blogroll...