java - Convert datatime and insert in MySQL

Question

I have to import a CVS file containing 120k rows. The first 6 columns contain the date and time separately, ie: year, month, day, hour, minutes, seconds.

I imported them into Java:

int year = 2016
int month = 5
int day = 23
int hour = 15
int minutes = 57
int seconds = 22 

How can I convert this format to a format compatible with MySQL (DATETIME)?

I also have a GMT column, i.e. "GMT +0200". Can I convert this data too in a DATETIME?

Answer 1

One way you could do this is to build your string in this format:

yyyy-MM-DD HH:mm:ss

Then insert it.

INSERT INTO yourtable VALUES('2016-05-23 15:57:22')