duandang6111
2015-12-11 01:58 阅读 298

android mysql在textview中显示日期/时间

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";
  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

2条回答 默认 最新

  • 已采纳
    doutan5798 doutan5798 2015-12-11 02:28

    I don't have the ability to test this at the moment, but you might want to consider using SimpleDateFormat.

    Calendar calendar = Calendar.getInstance();
    SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
    displayDate.setText(dateFormat.format(calendar.getTime()));
    

    You should also consider using a locale as well.

    点赞 评论 复制链接分享
  • dsfgdsjfd78773 dsfgdsjfd78773 2015-12-11 02:28

    You can get the time from the Calendar as well:

    hh12 = cal.get(Calendar.HOUR); -- 12 hour format
    hh24 = cal.get(Calendar.HOUR_OF_DAY); -- 24 hour format
    min = cal.get(Calendar.MINUTE);
    sec = cal.get(Calendar.SECOND);
    

    Then you can append it to your displayDate variable.

    Learn more about Calendar class here.

    点赞 评论 复制链接分享

相关推荐