Home / Questions / 13275
Accepted
El Cóndor
Asked: 2020-06-09 11:34:04 +0800 CST 2020-06-09 11:34:04 +0800 CST

How to convert String to Date MySQL in Android?

  • 772

Hello, I have a question about the best way to convert a string to a date in android.

fechauso = (EditText)findViewById(R.id.txt_fechadeuso);
String fechausoo = fechauso.getText().toString();

I want to convert it to date because just as I have it when saving it in a mysql database in a Date type field, it saves it like this:

0000-00-00

I am trying to solve it in the following way:

String newfecha = fechauso.getText().toString();
        try {
            SimpleDateFormat sdf = new SimpleDateFormat("dd-MM-yyyy");
            Date fecha = sdf.parse(newfecha);
        } catch (ParseException e){
            e.printStackTrace();
        }

nameValuePairs = new ArrayList<NameValuePair>(1);
 nameValuePairs.add(new BasicNameValuePair("fecha_prestamo",newfecha.trim()));

but it gives me the following error:

Incopatible types:
Required: java.sql.Date;
Found: java.util.Date

amount as follows:

import java.sql.Date;

but even so it continues to mark the error, I apologize if I'm asking something very basic, but seriously I'm lost...

java

3 Answers

  1. Best Answer

    This would be an example to convert a Stringto Date, using the classes: import java.text.DateFormat; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.Date; import java.text.DateFormat; import java.util.Locale;

      try {
    String stringDate = "Junio 8, 2016";
    Locale espanol = new Locale("es", "ES");
    DateFormat format = new SimpleDateFormat("MMMM d, yyyy", espanol);
    Date date = format.parse(stringDate); //Obtienes el String como Date.
    Log.i("INFO", date.toString());
    } catch (ParseException e) {
        e.printStackTrace();
    }

    You must take into account that as input you must have a Stringcontaining the text in a format that can be converted to Date.

    Another way can be simply, without using Locale :

      String stringDate= "Junio 8, 2016";
  DateFormat format = new SimpleDateFormat("MMMM d, yyyy");
  Date date = format.parse(stringDate);

    Update: It seems to me that this question fell "short", what you need is not only to convert: "String to Date in Android", what you need is, based on a date text entered in an EditText, change the format to other. The first thing you have to do is define what format should be entered in your EditText (you could add a validator to ensure users don't make mistakes) and also define the format you want to obtain.

    in your case you need to convert 2016-6-8to 2016-06-08 we can do it this way using this method, which you can use to define any input and output format:

       private static String convierteFecha(String stringFechaEntrada, String formatoEntrada, String formatoSalida){
        Log.i("TAG", "stringFechaEntrada :" +  stringFechaEntrada);
        //Definimos formato del string que ingresamos.
        SimpleDateFormat sdf = new SimpleDateFormat(formatoEntrada);
        try {
            Date date = sdf.parse(stringFechaEntrada);
            //Definimos formato del string que deseamos obtener.
            sdf = new SimpleDateFormat(formatoSalida);
            String stringFechaSalida = sdf.format(date);
            Log.i("TAG", "stringFechaSalida :" +  stringFechaSalida);
             Date dateSalida = sdf.parse(stringFechaSalida);
            //Log.i("TAG", "dateSalida :" +  dateSalida);
            return stringFechaSalida;
        }catch (Exception e) {
            e.printStackTrace();
            return "";
        }
    }

    If we call the above method:

     Log.i("INFO : " , convierteFecha("2016-6-8", "yyyy-MM-dd", "yyyy-MM-dd"));

    we can get as a result2016-06-08

    With the same method you can change the output format:

    Log.i("INFO : " , convierteFecha("2016-6-8", "yyyy-MM-dd", "dd/MM/yyyy hh:mm:ss.SSS"));

    to get08/06/2016 12:00:00.000

    even change the input data

    Log.i("INFO : " , convierteFecha("18 Apr 2012", "dd MMM yyyy", "dd/MM/yyyy hh:mm:ss.SSS"));

    getting18/04/2012 12:00:00.000

    • 3

  2. As I see the situation, you are doing the parse correctly from String to Date. The error I see is that you need a sql.Date to save in your database, the SimpleDateFormat returns a util.Date, the simple solution is to parse util.Date to sql.Date, which would be something as simple as .

    java.util.Date myUtilDate = new java.util.Date(System.currentTimeMillis()); //current date in Util

java.sql.Date mySqlDate = new java.sql.Date(myDateUtil.getTime()); //My SQL date..

    or even better

    DateFormat format = new SimpleDateFormat("MMMM d, yyyy", espanol);
java.sql.Date date = new java.sql.Date(format.parse(stringDate).getTime());

    Already with your date in sql.Date you can save it in the database.

    • 0

  3. Annex capture of my code and placement of the same: enter image description here

    • 0