Mohit Agrawal

Success is Journey it's not a destination

Menu

  • Home
  • Sql server 2008
  • Differences

April 29, 2008

month name in SQL Server 2000

DATENAME ( datepart , date )

DatePart ::

  1. mm month
  2. yy,yyyy year
  3. dd, d day

etc.......

Example :

select datename(mm,getdate())

or

select datename(month,getdate())

Posted by Mohit
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: Sql Server

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Search This Blog

Index

  • ►  2017 (1)
    • ►  February (1)
  • ►  2016 (1)
    • ►  February (1)
  • ►  2014 (2)
    • ►  March (2)
  • ►  2013 (1)
    • ►  January (1)
  • ►  2012 (3)
    • ►  December (1)
    • ►  October (1)
    • ►  February (1)
  • ►  2011 (1)
    • ►  March (1)
  • ►  2010 (4)
    • ►  May (2)
    • ►  March (2)
  • ►  2009 (22)
    • ►  November (1)
    • ►  October (6)
    • ►  August (3)
    • ►  July (2)
    • ►  June (3)
    • ►  May (3)
    • ►  March (4)
  • ▼  2008 (17)
    • ►  December (1)
    • ►  September (1)
    • ►  August (1)
    • ▼  April (2)
      • month name in SQL Server 2000
      • Magic table or Virtual Table
    • ►  February (12)
Mohit
View my complete profile

Blogs

  • AngularJS
  • Asp.net
  • Vb.net Link
  • Obect Oriented Programming
Ethereal theme. Powered by Blogger.