Question 128739 in Android Studio Question posted in
The official documentation can be found here.

Android Studio – Get all month from colums sql in java

I have table "TableHome", column name "Date" in database "DatabaseHome.db" contains data like this

5 January 2021
6 October 2021
10 December 2021

I want to take the month name for each year to generate monthly statistics, what sytax should I use in sql? and how to have that data converted into arraylist in java without duplicate items?

Tags:

2

Answers


  1. 0

    To convert the above dates to month int values use

    SELECT month(str_to_date('10 December 2021', '%d %M %Y')) as month;

    To summarise for a month you need to sum(or count depending what you want) and group by column one,

    so something like

    SELECT month(str_to_date(dateCol, '%d %M %Y')) as month, 
                         sum(someOtherCol) from mytable group by 1;
    Login or Signup to reply.
  2. 0

    You should try with MONTHNAME(DATE) to get Month in String and DISTINCT to remove dupilcate items

    select distinct(monthname(str_to_date(col1, '%d %M %y'))) as month
from table1

    dbfiddle here

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search