Changing values from Cursor using SimpleCursorAdapter

Question

Hey guys!!

I have database table with the columns {Name, Time (UTC format) , Latitude, Longitude}

I display the table using a ListActivity with a SimpleCursorAdapter.

I would like that the column Time show the time in a human readable format (13-07-2010 10:40) rather than in UTC format (18190109089).

How can I specify that the values from column Time need some filtering/adaptation?

POSSIBLE SOLUTION (with a problem):

SimpleCursorAdapter offers the method:

setCursorToStringConverter(SimpleCursorAdapter.CursorToStringConverter cursorToStringConverter);

to specify how a class that is able to convert a Cursor to CharSequence (convertToString(Cursor cursor). Anyway I don't know in which format should be the return CharSequence paramater!

Answer 1

You can use setViewBinder(), or subclass SimpleCursorAdapter and override bindView().

Answer 2

You can use SQLite syntax on that column to format the date.

Something like this will do it

SELECT strftime('%d-%m-%Y %H:%M',1092941466,'unixepoch');

SELECT strftime('%d-%m-%Y %H:%M',timecol,'unixepoch');