Converting android date time into mysql datetime

Question

Is there any way I can get datetime format like 'YYYY-MM-DD HH:MM:SS' to be stored as datetime format in mysql from android date of format 'MM-DD-YY' and time of format 'HH:MM'

Input : android date 'MM-DD-YY' and android time 'HH:MM'
Output: mysql datetime 'YYYY-MM-DD HH:MM:SS'

Answer 1

Use SimpleDateFormat to parse and format the dates :

// Parse the input date
SimpleDateFormat fmt = new SimpleDateFormat("MM-dd-yyyy HH:mm");
Date inputDate = fmt.parse("10-22-2011 01:00");

// Create the MySQL datetime string
fmt = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String dateString = fmt.format(inputDate);