The date fetched from database is displayed wrong

Question

I am new to android and I am stuck at one place. I wanted to fetch the date from mysql database and display it in android app.

The code for android application

 try {
JSONArray data = response.getJSONArray("std");
String result[]=new String[data.length()];
for (int i = 0; i < data.length(); i++)
{
    JSONObject obj = data.getJSONObject(i);
    name = obj.getString("Name");
    fromdate=obj.getString("From");
    todate = obj.getString("To");
    DateFormat formatter = new SimpleDateFormat("dd-MM-yyyy");
    Calendar cal=Calendar.getInstance();
    Date fd=formatter.parse(fromdate);
   cal.setTime(fd);
   from1=cal.getTimeInMillis();
   Date td=formatter.parse(todate);
   cal.setTime(td);
   to1=cal.getTimeInMillis();              
   date= DateUtils.formatDateRange( Main2Activity.this, from1, to1,  
     DateUtils.FORMAT_SHOW_YEAR );
   result[i]=""+name+"\n"+date;
  }

JSON FILE

<?php
$result=mysqli_query($link,"select * from oTrip");
$data=array();
$rows=mysqli_num_rows($result);
while($rec=mysqli_fetch_assoc($result))
{
$data[]=$rec;
}
header('Content-Type: application/json');
echo json_encode(array("std" =>$data));
?>

And the output is

Please help out with this!! Thank You.

@whenthemorningcomes DateUtils is Api class of `android.text.format `package . — ADM, Dec 21 '17 at 10:03
Check [this](https://stackoverflow.com/questions/35760788/dateutils-formatdaterange-issues-when-formatting-date-range) out. — Jay, Dec 21 '17 at 10:13
@ADM $result=mysqli_query($link,"select * from oTrip"); $data=array(); $rows=mysqli_num_rows($result); while($rec=mysqli_fetch_assoc($result)) { $data[]=$rec; } header('Content-Type: application/json'); echo json_encode(array("std" =>$data)); — Kruti Karvade, Dec 21 '17 at 10:20
$result=mysqli_query($link,"select * from oTrip"); $data=array(); $rows=mysqli_num_rows($result); while($rec=mysqli_fetch_assoc($result)) { $data[]=$rec; } header('Content-Type: application/json'); echo json_encode(array("std" =>$data)); @kamalverma — Kruti Karvade, Dec 21 '17 at 10:25
echo json_encode(array("std" =>$data)); , provide its echo string,that you are using to parse json data — kamal verma, Dec 21 '17 at 10:27
MySQL default date format is 'yyyy-MM-dd'. Have you checked that ? — t0mm13b, Dec 21 '17 at 10:30
@KrutiKarvade You were asked to supply the JSON, you still have not. Why? If you knew of the default format, why did you not format it in such a way that it can be easily consumed. *Hint:* use ISO8601 formatting before putting it into a JSON, makes life so much easier and avoid any date parsing issues. — t0mm13b, Dec 21 '17 at 10:46
@t0mm13b just look I have updated it. And I wanted to have the display in dd-mm-yyyy format — Kruti Karvade, Dec 21 '17 at 10:54
@KrutiKarvade where is the JSON? All you updated in this question is the php code. Show us the actual data. — t0mm13b, Dec 21 '17 at 10:56
what is the format of date stored in your database? And how do you want to display it? — global_warming, Dec 21 '17 at 12:05
@global_warming in database it is stored in yyyy-MM-dd and i want to display the date range in dd-mm-yyyy — Kruti Karvade, Dec 21 '17 at 12:15

score 0 · Answer 1 · answered Dec 21 '17 at 10:19

0

Change "dd-MM-yyyy" to "dd/MM/yyyy"

answered Dec 21 '17 at 10:19

Suresh Kumar Bairwa

1
1

While this code snippet may be the solution, [including an explanation](//meta.stackexchange.com/questions/114762/explaining-entirely-‌code-based-answers) really helps to improve the quality of your post. Remember that you are answering the question for readers in the future, and those people might not know the reasons for your code suggestion. – yivi Dec 21 '17 at 11:29

score 0 · Answer 2 · answered Dec 21 '17 at 10:58

0

You can do this,

 fromdate=obj.getLong("From");
 SimpleDateFormat sdf = new SimpleDateFormat("HH:mm dd/MM/yyyy");
     sdf.format(new Date(fromdate));

answered Dec 21 '17 at 10:58

Ritu Suman Mohanty

734
1
6
15

This is not helping..can you suggest something else? – Kruti Karvade Dec 21 '17 at 12:16
it's working in my case you show me your from date value – Ritu Suman Mohanty Dec 21 '17 at 12:18
so for using long i have to store date in database in bigint format? – Kruti Karvade Dec 21 '17 at 12:34

global_warming · Accepted Answer · 2017-12-21T12:52:15.117

Use this:

 JSONObject obj = data.getJSONObject(i);
 name = obj.getString("Name");
 fromdate=obj.getString("From");
 todate = obj.getString("To");
 DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
 Date fd=formatter.parse(fromdate);
 Date td=formatter.parse(todate);
 DateFormat newFormatter = new SimpleDateFormat("dd-MM-yyyy");
 String newFromdate = newFormatter.format(fd);
 String newTodate = newFormatter.format(td);
 date = newFromdate + " - " + newTodate;
 result[i]=""+name+"\n"+date;

You have to parse date in given JSON format and then change that parsed date into new format using another formatter.

You can use one-liners as:

DateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
DateFormat newFormatter = new SimpleDateFormat("dd-MM-yyyy");
fromdate = newFormatter.format(formatter.parse(fromdate));
todate = newFormatter.format(formatter.parse(todate));

The date fetched from database is displayed wrong

3 Answers3