java sql date format

// This is an example to get the current date in java, with an sql date format

/*
I am using the imports below:
import java.time.LocalDateTime
import java.time.format.DateTimeFormatter
*/

DateTimeFormatter dtf = DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss");  
LocalDateTime now = LocalDateTime.now();
String dateTime = dtf.format(now);

// the dateTime variable is now ready to be inserted in mysql
// insert it as a String and it will be inserted in mysql as a dateTime