DateName and DatePart in SQL SERVER

DateName and DatePart in SQL SERVER



select 
datepart(month,getdate()) [Date] -- returns integer (1,2,3...)
,datepart(year,getdate()) [Year]-- returns integer
,datename(month,getdate()) [Month]-- returns string ('September',...)



Output:

Share this post :

Post a Comment

Please give your valuable feedback on this post. You can submit any ASP.NET article here. We will post that article in this website by your name.

 
Support : Ranga Rajesh Kumar
Copyright © 2012. ASP.NET Examples - All Rights Reserved
Site Designed by Ranga Rajesh Kumar