sqlite select query round of double value
- by Scorpion
I have stored location in my sqlite database.
CREATE TABLE city
(
latitude NUMERIC,
longitude NUMERIC
)
Below are the value :-
latitude = 41.0776605;//actual value in db - NUMERIC stored as DB
longitude = -74.170086;//actual value in db - NUMERIC stored as DB
final String query = "SELECT * FROM city";
cursor = myDataBase.rawQuery(query, null);
if (null != cursor) {
while (cursor.moveToNext()) {
Log.i(TAG, "Latitude == " + cursor.getDouble(cursor.getColumnIndex("latitude")));
Log.i(TAG, "Longitude == " + cursor.getDouble(cursor.getColumnIndex("longitude")));
}
}
Result :-
Latitude = 40.4127
Longitude = -74.25252
I don't want round off this values. Is there any way to solve this problem.
