Loading ...

Who is online?  0 guests and 0 members
home  »  blogs  »  Sumit Arora  »  Date Format in SQL

Date Format in SQL

(0)
(2113)
0
/5
Avg: 0/5: (0 votes)

posted 3/6/2009  by Sumit Arora

I wanted the date format from SQL in this way January, 2008. After doing searching I finally found the way to do it. Here is the solution:

SELECT
    DATENAME(month, DateCreated) AS ByMonth,
     DATENAME(yyyy, DateCreated) AS ByYear,
     COUNT(*) AS TotalCount FROM Test where userId=@UserID
     GROUP BY
     DATENAME(mm, DateCreated),
     DATENAME(yyyy, DateCreated)
     ORDER BY ByYear DESC

The output will be in this way now
ByMonth    ByYear    TotalCount
March    2009    6
January    2007    4

Product Spotlight

ASP.NET Hosting Spotlight
 

Comments (no comments yet)

Add a new comment

Confirm

Latest community blog posts

  • ASP.NET: Form authentication timeout in web.config overriding the manual ticket timeout
    7 days ago by Raghav Khunger
    While working with one of the sample application I noticed that form authentication timeout in web.config was overriding the manual ticket's (which we created via code) timeout. Below is the code which was written in the application: var ticket = new FormsAuthenticationTicket(1, "UserName", DateTime...
  • jQuery: Set cursor position in textbox
    4/13/2012 by Raghav Khunger
    In this blog I will show how to select a range of characters in textbox with jquery. In my demo I have used one textbox and one button. On click of button arange of characters in textbox will be selected. Below is the sample code: <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="ser...
  • Could not load file or assembly 'Newtonsoft.Json, Version=3.5.0.0...
    9 days ago by Raghav Khunger
    Recently we moved from Newtonsoft.Json 3.5 to 4.0 version. We noticed that we were getting Could not load file or assembly 'Newtonsoft.Json, Version=3.5.0.0.. while working with Twitter authentication which we were using in our application. The third party dll which we were using for Twitter authent...
  • jQuery Mobile Login Dialog Box
    11/17/2010 by Tim Eisenhauer
    PRODUCT SPOTLIGHT This is an addition to my series of blog posts on jQuery Mobile: jQuery Mobile Introduction & Tips To Get Started jQuery Mobile Getting Started So, if you've been following my posts so far, you should have a good overview of jQuery Mobile, it's documentation, how to set up your...
  • message icon with count disply.
    3/28/2012 by SONAL KHAIRE
    add message icon with count displayed on it as new messages come into my gridview. i want to do this in asp.net for web application.

Sumit Arora's latest blog posts

Product Spotlight

ASP.NET Hosting Spotlight

 

Quick Vote

What kind of email newsletter would you prefer to receive from CodeAsp.Net?