How Do I Store Timepicker Data In My Simple Record Keeping App?

I've created a simple record keeping application using various resources around the internet. I'm able to successfully store text data - however when I attempt to incorporate a Tim

Solution 1:

in you create table statement define a type

CREATETABLE ...... dtField date, tmpName Text.....

use following for saving date as text

//sample dateformat - 2013-03-2113:12:00
android.text.format.DateFormat.format("yyyy-MM-dd hh:mm:ss", dtDate.getTime())