i am trying to display current date/time in a textview, i have managed to display the date but do not know how to display the time, the format of the date/time must be '2015-12-10 01:52:23' as it will be stored in a database field TIMESTAMP. Heres what i have as of yet (Prints date '2015-12-10' only)
displayDate = (TextView) findViewById(R.id.DATE);
final Calendar cal = Calendar.getInstance();
yy = cal.get(Calendar.YEAR);
mm = cal.get(Calendar.MONTH);
dd = cal.get(Calendar.DAY_OF_MONTH);
// set current date into textview
displayDate.setText(new StringBuilder()
// Month is 0 based, just add 1
.append(yy).append(" ").append("-").append(mm + 1).append("-")
.append(dd));
It is then passed onto this: final String datetime = displayDate.getText().toString().trim();
which is added into the database:
@Override
protected String doInBackground(Void... v) {
HashMap<String,String> params = new HashMap<>();
params.put(Config.KEY_EMP_ID, TextUserID);
params.put(Config.KEY_LAT,lat);
params.put(Config.KEY_LON,lon);
Config is a java file which has the keys and JSON tags to query the database using php:
//Keys that will be used to send the request to php scripts
public static final String KEY_EMP_ID = "UserID";
public static final String KEY_LAT = "Latitude";
public static final String KEY_LON = "Longitude";
public static final String KEY_TIMEINSERTED = "TimeInserted";