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'
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); 
I find it much easier to store dates as ints in the database e.g. long millis - date.getTime(). Then when you want to display it you can convert it back to a date and add whatever formatting suits your required output.
