mabus Posted August 8, 2008 Share Posted August 8, 2008 Given records containing a DateTime column, how do I get a count of records for each month? I need results to resemble something like the following: June 2008, 13 July 2008, 10 August 2008, 15 ... ... Please send in your replies.. thanks Quote Link to comment Share on other sites More sharing options...
vikramjeet.singla Posted August 8, 2008 Share Posted August 8, 2008 you have to group by this month and year of your date column.... Quote Link to comment Share on other sites More sharing options...
fenway Posted August 9, 2008 Share Posted August 9, 2008 YEARMONTH is a valid EXTRACT format for dates. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.