Convert String to Date mysql

Question

I need to convert a string to date to allow me insert information in mysql table:

I tried this:

System.out.println("Escribe la fecha de nacimiento de socio:");
//Traduction to english:        set the date of birthday //

String fechaSocio  = sc.next();

Date fecha = null;
try {
  fecha = new SimpleDateFormat("ddMMyyyy").parse(fechaSocio);
} catch (ParseException e) {
  // TODO Auto-generated catch block
  e.printStackTrace();
}

but It's converting like that: Thu Mar 21 00:00:00 CET 1996

I need to convert to this :

01-01-1987 or 01011987

public class SocioDao {
static ClaseConexion conexion = new ClaseConexion();

public void insertar(Socio misocio){

System.out.println(misocio.getDATA_NAIXEMENT());
System.out.println("..........................");


  try {

        Statement statuo = conexion.getConnection().createStatement();


        statuo.executeUpdate("insert into socis(CODI_SOCI,DNI,NOM,COGNOMS,"
                + "DATA_NAIXEMENT,ADRECA,POBLACIO,TELEFON) values ('"
                + misocio.getCODI_SOCI() + "','" + misocio.getDNI()
                + "',' " + misocio.getNOM() + "','" + misocio.getCOGNOMS()
                + "','" + misocio.getDATA_NAIXEMENT() + "','"
                + misocio.getADREÇA() + "','" + misocio.getPOBLACIO()
                + "','" + misocio.getTELEFON() + "')");

        statuo.close();
        conexion.desconectar();
        System.out.println("Socio añadido correctamente");

    } catch (Exception e) {
        System.out.println("No se puede añadir un nuevo socio");




    }

}

}

You've only shown us the parsing. You haven't shown us how you try to set the date in the MySQL query. — Sotirios Delimanolis
– Sotirios Delimanolis, Commented Mar 8, 2014 at 20:46

Community · Accepted Answer · 2020-06-20 09:12:55Z

4

It seems like you are trying to pass a Date as a String in your MySQL query.

Don't. Instead use the appropriate date setter method in the PreparedStatement class.

Remember, a Date doesn't have a format. A format is only for displaying a date.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Mar 8, 2014 at 20:49

Sotirios Delimanolis

281k62 gold badges718 silver badges744 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Basil Bourque Over a year ago

See this other answer by BalusC for an example of what this answer suggests.

KhAn SaAb · Accepted Answer · 2014-03-08 20:59:18Z

0

Use mysql function if you are trying to insert date in database..

for example:

INSERT INTO test (sampledate) VALUES (CURDATE());

answered Mar 8, 2014 at 20:59

KhAn SaAb

5,4166 gold badges34 silver badges55 bronze badges

Collectives™ on Stack Overflow

Convert String to Date mysql

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related