After looking through many of the threads in stackoverflow and cant seem to find the correct method im looking for. If anyone could shine a bit of light it would be great.

So I populated a JCombo Box with SQL Dates but in doing so I formatted them to using SimpleDateFormat which converted them into a string with the format dd/MM/yyyy.

When the program is running he can select a certain date to query the database and so here the problem

Ive managed to make a String with a format of yyyy/MM/dd using string.split saving it into an array and ordering them in another string

Is There A Way To Convert This String (2014/04/13) into an SQL Date so I can query my database OR am I going about it incorrect

Thank You,

Is There A Way To Convert This String (2014/04/13) into an SQL Date?

Sample code:

    SimpleDateFormat format = new SimpleDateFormat("yyyy/MM/dd");



    try {

        java.util.Date utilDate = format.parse("2014/04/13");

        java.sql.Date sqlDate = new java.sql.Date(utilDate.getTime());

        System.out.println(sqlDate);

    } catch (ParseException e) {

        e.printStackTrace();

    }

output:

2014-04-13

use SimpleDateFormat to parse a string into java.util.Date.

use java.sql.Date(miliseconds) constructor.

Use java.util.SimpleDateFormat

An example here:

    SimpleDateFormat sdf = new SimpleDateFormat("yyyy/MM/dd");

    java.lang.Date langDate = sdf.parse("2014/04/13");

    java.sql.Date sqlDate = new java.sql.Date(langDate.getTime());

tl;dr

myPreparedStatement.setObject( 

    … , 

    LocalDate.parse( 

        "23/01/2018" , 

        DateTimeFormatter.ofPattern( "dd/MM/uuuu" )

    ) 

) ;

java.time

The modern approach uses the java.time classes that supplanted the terrible Date/Calendar/SimpleDateFormat classes.

The LocalDate class represents a date-only value without time-of-day and without time zone or offset-from-UTC.

Define a formatting pattern to match your input strings.

String input = "23/01/2018" ; 

DateTimeFormatter f = DateTimeFormatter.ofPattern( "dd/MM/uuuu" ) ;

LocalDate localDate = LocalDate.parse( input , f ) ;

String output = localDate.toString() ;  // Generate text in standard ISO 8601 format.

JDBC 4.2

As of JDBC 4.2, we can exchange java.time objects with the database. Use smart objects rather than dumb text for database interactions.

myPreparedStatement.setObject( … , localDate ) ;

About java.time

The java.time framework is built into Java 8 and later. These classes supplant the troublesome old legacy date-time classes such as java.util.Date, Calendar, & SimpleDateFormat.

The Joda-Time project, now in maintenance mode, advises migration to the java.time classes.

To learn more, see the Oracle Tutorial. And search Stack Overflow for many examples and explanations. Specification is JSR 310.

You may exchange java.time objects directly with your database. Use a JDBC driver compliant with JDBC 4.2 or later. No need for strings, no need for java.sql.* classes.

Where to obtain the java.time classes?

• 
  Java SE 8, Java SE 9, Java SE 10, Java SE 11, and later - Part of the standard Java API with a bundled implementation.
  
  
  
  
  • Java 9 adds some minor features and fixes.
  
  
  
  


• 
  Java SE 6 and Java SE 7
  
  
  
  
  • Most of the java.time functionality is back-ported to Java 6 & 7 in ThreeTen-Backport.
  
  
  
  


• 
  Android
  
  
  
  
  • Later versions of Android bundle implementations of the java.time classes.
  
  
  • For earlier Android (<26), the ThreeTenABP project adapts ThreeTen-Backport (mentioned above). See How to use ThreeTenABP….
  
  
  
  

The ThreeTen-Extra project extends java.time with additional classes. This project is a proving ground for possible future additions to java.time. You may find some useful classes here such as Interval, YearWeek, YearQuarter, and more.