CODEWITHSUNDEEP
androiddatabasedatetimelistviewsimplecursoradapter
ekatz
ekatz

Reputation: 973

Android question: When using SimpleCursorAdapter, how can I format one of the columns

I'm trying to create a list that is mapped to a database query, however, one of the fields in the database is a timestamp which when displayed should be displayed as a date like "Wednesday, March 2" instead of the actual value in the database which is something like 1299517239487...

I can solve this by rephrasing the query or by decorating the cursor after I do the query, but I would much rather have the simple cursor adapter display this column in that specific way.

Does anyone have any idea on how to do it?

some code:

// the desired columns to be bound
String[] columns = new String[] { DBHelper.COL_START_TIME, DBHelper.COL_AMOUNT};
// the XML defined views which the data will be bound to
int[] to = new int[] { R.id.dayMonthDate, R.id.amount};

// create the adapter using the cursor pointing to the desired data as well as the layout information
SimpleCursorAdapter mAdapter = new SimpleCursorAdapter(this, R.layout.single_activity,cursor, columns, to);

I would like to be able to add some kind of post processor to the adapter in order to fix that.

Thanks!

Upvotes: 0

Views: 425

Answers (1)

Robby Pond
Robby Pond

Reputation: 73484

You can use the setViewBinder() method of SimpleCursorAdapter to have a ViewBinder manually set the values for the views but that will get called for every column.

Upvotes: 1

Related Questions